How To Obtain The Top 10%

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SMH - 25 Mar 2008 22:51 GMT

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

Reply to this Message

Tyro - 25 Mar 2008 22:58 GMT

What version of Excel?

Tyro

>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.
[quoted text clipped - 6 lines]
>
> Any assistance would be appreciated!!

Reply to this Message

Gary''s Student - 25 Mar 2008 23:44 GMT

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

Signature

Gary''s Student - gsnu200775

> 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.
[quoted text clipped - 5 lines]
>
> Any assistance would be appreciated!!

Reply to this Message

Debra Dalgleish - 26 Mar 2008 00:06 GMT

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

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

SMH - 26 Mar 2008 14:09 GMT

It worked! Thank you so much! :)

> If the data is in a table on the worksheet, select a cell in the table,
> and choose Data>Filter>AutoFilter
[quoted text clipped - 12 lines]
> >
> > Any assistance would be appreciated!!

Reply to this Message