Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
unsorted lookup
I need a formula, such as lookup, to extract data from an unsorted column. In
this case i'm tring to find the start time for the lunch period. A B C random text 7:00a 10:00a random text 10:00a 12:00p Lunch 12:00p 1:00p random text 1:00p 3:00p =lookup("lunch",A:A,B:B) wont work because A:A is not sorted. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup unsorted list | Excel Discussion (Misc queries) | |||
How do I find top 3 in an unsorted list? | Excel Worksheet Functions | |||
lookup unsorted list | Excel Discussion (Misc queries) | |||
An unsorted list in vlookup | Excel Worksheet Functions | |||
Matching unsorted lookup values | Excel Worksheet Functions |