Hi i was running if there was a percentile IF function or a way to run
something similar to an average if function.
Lets say I have a data set like below
a 6
b 1
b 2
b 3
a 4
b 5
a 10
c 12
What I want to achieve is to find the percentile of all data points that are
taged "a".
The average if function for this data looks like =AVERAGEIF(D1:D8,"a",E1:E8)
So ideally I want to be able to have a =PERCENTILEIF(D1:D8,"a",E1:E8),
sorting column d is no appropriare as different filters are constantly
applied to this data set.
Potentially I would want to run a LOOKUP loop of something like that
?