asked on
How Excel calculates the top 10% of values in Conditional Formatting
I want to get a better understanding of the "top 10%" feature in Conditional Formatting in Excel - this is my understanding, it takes the full range and identifies the entries that correspond to the highest 10% in value i.e. the products with prices that fall into the top 10% of the range. Or is it something else?
Microsoft ExcelMicrosoft Office
Last Comment
agwalsh
I believe percentiles are used to calculate the top-n%.
This example might help clarify.
EE11.xlsx
EE11.xlsx
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you for that explanation - has really helped to clarify things!
https://answers.microsoft.com/en-us/msoffice/forum/all/conditional-formatting-topbottom-rules-top-10/58cab580-f182-4275-8e9a-c47e8e3245c7