How To Obtain The Top 10%
What version of Excel?
Tyro
"SMH" wrote in message
...
I have two columns displaying over 16K rows of data. Column A is person
1,2,3,4, etc. and Column B is their corresponding point balance.
How can I find the top 10% and bottom 20% of those people?
I only found a sort option using a Pivot Table for the top 10, but it
didn't
allow me to say 10%.
Any assistance would be appreciated!!
|