Hi
I have a lot of data where I am trying to get the top 10% or top 50 (whichever is the smallest number) highlighted.
I am currently using =IF(AC8648="","FALSE",AC8648>=PERCENTILE.EXC($AC$2:$AC$10375,0.9)), to get the top 10%, which worked until I got a data set as large as this one (the first bit is just to remove the blanks I have). Now I need to limit it to just the top 50 (what I want is a formula that can do both so I don't need to use a different formula for each sheet, as I will be giving this to others to use).
Thanks!
Bookmarks