| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highest value in column b returning column a
What I have is two columns Column A is the Emp ID column B is "number of
times selected" What I am attempting is to list the top five Emp ID based on the number of times they were selected.The top five wuold list in different cells off to the side. This gets updated daily and is ever changing. Instead of having to sort everytime additions are made I am trying to make it a bit easier. Thanks for you help! EXAMPLE: A B J7 K7 L7 M7 N7 1 66 2 69 5 3 4 2 1 3 74 4 71 5 79 6 68 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Excel - returning column headers in a seperate column | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
| looking up figures in a column and selecting next highest match | Excel Worksheet Functions | |||
Threaded Mode
