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