| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Picking second high from a list
I have a list like the following:
A = 8 B = 8 C = 6 D = 5 E = 5 F = 3 G = 2 I am using the VLOOKUP and LARGE formula in order to pick the highest three. I can properly pick the first and the third but not the second because the first and the second are equa. How can I do it?? Thank |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average a list with high and low ignored | Excel Worksheet Functions | |||
| Picking the list from data | Excel Worksheet Functions | |||
| Picking every monday from a list of dates | Excel Discussion (Misc queries) | |||
| how do i sort a list from cells by picking a specific letter? | Excel Discussion (Misc queries) | |||
| Picking Values from a list | Excel Worksheet Functions | |||
Threaded Mode
