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.