| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple entries last date
Hi All, I have a column of customers with their corresponding visit date. I
need to find the last time I visited each customer. Customer Date A shop 1/1/9 A Garage 2/1/9 An Office 2/1/9 A Garage 5/2/9 A shop 5/2/9 etc. Any helpmost appreciated |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple entries last date
Hi,
The dates look to be sorted so try this =LOOKUP(2,1/(A2:A1000=A2),B2:B1000) It will return a number which you must format as a date. Mike "Simo" wrote: Hi All, I have a column of customers with their corresponding visit date. I need to find the last time I visited each customer. Customer Date A shop 1/1/9 A Garage 2/1/9 An Office 2/1/9 A Garage 5/2/9 A shop 5/2/9 etc. Any helpmost appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter latest date from multiple date entries | Excel Worksheet Functions | |||
| multiple entries / multiple criteria | Excel Discussion (Misc queries) | |||
| Combine Multiple Entries with differing amounts of entries | Excel Worksheet Functions | |||
| look for multiple entries | Excel Worksheet Functions | |||
| Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
Linear Mode
