| 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. |
| 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) | |||
Threaded Mode
