Hi,

I am looking for a way to generate multiple 10% and 90% percentiles of a range of values (DAY) within several YEARs. I have columns A (YEAR) and B (DAY), and I want to generate the percentiles for each YEAR. If Pivot Tables had a bit more to it then this would be the obvious way to go, but all I can get with it is AVERAGE, MIN, MAX etc.

Thanks for your help!
David