Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using LOOKUP without values in ascending order
I'm trying to use the LOOKUP function to search a LOOKUP VECTOR that is not
in ascending order. Putting the values in ascending order is not an option. Is there any way to use LOOKUP with these values? Row B has Names and Row C has their corresponding race times in chronological order. I'm trying generate a Top 10 times list (with the corresponding names) from the data. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Function Not in Ascending Order | Excel Worksheet Functions | |||
eliminate repeat values from a list of ascending order | Excel Worksheet Functions | |||
How do I # my rows in ascending order. | Excel Worksheet Functions | |||
How do I lookup a value in a array that is not in ascending order | Excel Worksheet Functions | |||
Graph values in ascending order | Excel Discussion (Misc queries) |