| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup unsorted list
I have a very simple two column list. Col-A is "Products" col-B is "Date
Purchase". Col-A is un-sorted and various products are repeated several times. I want a lookup formula that would tell me the most recent date when a particular product was purchased. If col-A was sorted ascending, I could use =LOOKUP(1E+100,INDEX(A2:B8,MATCH(A12,A2:A8,1),0)). Can someone please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| returning values from an 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 | |||
Threaded Mode
