Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percent of a Spreadsheet Complete | Excel Worksheet Functions | |||
Conditional Formatting Bottom 'n' percent | Excel Discussion (Misc queries) | |||
How can I change all values in a spreadsheet by a certain percent | Excel Discussion (Misc queries) | |||
Percent change between two worksheets on same spreadsheet | Excel Discussion (Misc queries) | |||
Increasing a whole Spreadsheet by a percent | Excel Discussion (Misc queries) |