Conditional Percentile
 

Hi

I want to retrieve PERCENTILE information using the percentile function
but the range I need to look at depends on another variable. E.g if I
have the following in cols A and B :

a 1
b 10
a 2
b 20
a 3

I would like to use a formula to retrieve the 50th percentile for:

a's. this would be (1, 2, 3) = 2
b's. this would be (10, 20) = 15

Any ideas if this can be achieved using formulas or is some VBA
required?


--
blatham
------------------------------------------------------------------------
blatham's Profile: http://www.excelforum.com/member.php...o&userid=19441
View this thread: http://www.excelforum.com/showthread...hreadid=553225