Conditional percentile calculation

[volabos]

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]

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

[volabos]

Thank you.