How To Obtain The Top 10%

S

SMH

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!!
 
G

Gary''s Student

Sort the data by point balance. The top 10% would be rows 1 thru 1600. The
botttom 20% would be rows 12800 thru 16000
 
D

Debra Dalgleish

If the data is in a table on the worksheet, select a cell in the table,
and choose Data>Filter>AutoFilter
Click on the dropdown list that will appear in the Column B heading cell.
Choose Top 10
From the dropdowns, choose Top, 10, and Percent
or choose Bottom, 20, and Percent
 
S

SMH

It worked! Thank you so much! :)

Debra Dalgleish said:
If the data is in a table on the worksheet, select a cell in the table,
and choose Data>Filter>AutoFilter
Click on the dropdown list that will appear in the Column B heading cell.
Choose Top 10
From the dropdowns, choose Top, 10, and Percent
or choose Bottom, 20, and Percent
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Tables - Top 10 hide negatives values 0
Finding the top 10 12
Move Drop Down List to the Top of the Cell 0
Top 10 Ranking 10
Conditional format row if one cell is in "top 10" 4
Pivot Table - Controlling how many rows of data are displayed in t 1
Extracting data from spreadsheet to a graph 1
Filtering the top 5 transactions from a list of 10 reps 2

Top