PDA

View Full Version : [SOLVED] Conditional percentile calculation



volabos
08-10-2014, 04:09 AM
Hi,

I have a file which I attached here (File.xlsx)

I was basically trying to find some way, so that I can calculate Percentile for the 2nd column based on value at 1st column. Like, what is the 10th percentile of values corresponding to 'a' ???

Ordinary way to calculate it using =PERCENTILE(B2:B12, 0.1) would give percentile for all numbers.

Can somebody please help me how to do that?

Thanks for your help.

p45cal
08-10-2014, 10:26 AM
try array-entering (Ctrl+Shift+Enter rather than just Enter):
=PERCENTILE(IF(A2:A12="a",B2:B12), 0.1)

volabos
08-10-2014, 12:10 PM
Thank you.