B
blatham
Hi
I want to retrieve PERCENTILE information using the percentile functio
but the range I need to look at depends on another variable. E.g if
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 VB
required
I want to retrieve PERCENTILE information using the percentile functio
but the range I need to look at depends on another variable. E.g if
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 VB
required