Conditional percent rank

[rwcg2d]

I have a date column and a column that states "Include" or "Don't Include." I want to calculate the Percentile of each row in my data set given that they are marked to be included. Any thoughts on how to group them?

 

[James006]

Hi,

You can do it with an Array Formula ...

See Domenic's example ...https://www.mrexcel.com/forum/excel-questions/818272-percentrank-if-function.html#post3995211

HTH