Returning Bottom 10 Percent in another spreadsheet
 

I am looking for a way to take a list of data and transfer this to another
spreadsheet, identifying who the low performers for a metric might be. The
data is laid out as below.

A B C
Name Value Rank

There are hundreds of rows of data. I am wanting to return on a seperate
spreadsheet the only individuals who rank in the bottom 10% and their
corresponding information. I would like to generate a formula that will
allow this to autopopulate based on the amount of data each time the report
is modified.

Returning Bottom 10 Percent in another spreadsheet
 

Hi,

In the other sheet, you can use the SMALL function. So in a separate
function, type in 1-10 in G6:G15. Now in cell D6, use
=SMALL(Sheet1!$D$6:$D$16,G6) and copy down


--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Brandon" wrote in message
...
I am looking for a way to take a list of data and transfer this to another
spreadsheet, identifying who the low performers for a metric might be.
The
data is laid out as below.

A B C
Name Value Rank

There are hundreds of rows of data. I am wanting to return on a seperate
spreadsheet the only individuals who rank in the bottom 10% and their
corresponding information. I would like to generate a formula that will
allow this to autopopulate based on the amount of data each time the
report
is modified.