Help...

I would like to use the percentile function on column B, for example,dependant upon the entry on column A.

e.g. So if A = Red the percentile (B:B,0.95)

What would the formula for this be?

Thanks
Michelle