Hi

I have included a sample table.

State Priority Age P90 for A____ P90 for B___ P90 for C___
A 1 3
A 1 128
B 2 131
A 3 100
C 2 100
B 3 96
C 3 88
B 3 41
C 1 5
C 2 79

In order to find the P90 for all items in state "A" (column 1) I filter for
A and then copy paste the date in column 3 (Age) into another sheet and find
the percentile. I would like to know if there is a way to find the P90 for
all the states without having to manually do each state one at a time.

Sam