using percentile in an array formula

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

Hi,

I am trying to find the value of AF at the 25% percentile of AW in the
following array formula.

=IF(PERCENTILE(Exit_Date!$AW$184:$AW$228,0.25),Exit_Date!$AF$184:$AF$228)

I am getting a result but not the answer I am expecting.
Any ideas?

Bruce
 
You might try
=INDEX(AF$184:$AF$228,MATCH(PERCENTILE($AW$184:$AW$228,0.25),AW$184:$AW$228))
if your data values in AW are in ascending order,
but in that situation you could also use
=INDEX(AF184:AF228,1+0.25*ROWS(AW184:AW228))
 
Back
Top