| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find top 3 in an unsorted list?
I have a list of data that is unsorted (and I cannot sort the data for
special reasons), but I want to find the 3 largest in a column...so its like using the MAX function, but I need MAX 1, MAX 2nd, MAX 3rd. Here is an example: A B Company 1 $200,000 Company 2 $100,000 Company 3 $500,000 Company 4 $550,000 Company 5 $212,000 I would like to pull in order the 3 largest $550,000 $500,000 $212,000 Ideally I would like to pull the corresponding company also. Please help me out. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting names from an unsorted list. | Excel Worksheet Functions | |||
| One list unsorted, but two groups - I need to rank in each group | Excel Discussion (Misc queries) | |||
| Find the closest match to a reference number in a row of unsorted | Excel Worksheet Functions | |||
| lookup unsorted list | Excel Discussion (Misc queries) | |||
| An unsorted list in vlookup | Excel Worksheet Functions | |||
Threaded Mode
