| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Most recent receipt date for an item
Col A has a slew of part numbers with many of them repeated; Col B has
a transaction date for that item. On sheet 2, there's the list of items which appear in colum A on sheet 1 (none repeated on sheet 2). I'd like to populate ColumnB on sheet 2 with the most recent transaction date that matches up with the most recent transaction date in column B on sheet 1. Ideas? Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table: Most recent price for an item? | Excel Worksheet Functions | |||
| Most recent price per item | Excel Worksheet Functions | |||
| most recent date | Excel Discussion (Misc queries) | |||
| Looking up the most recent date | Excel Worksheet Functions | |||
| clipboard in Excel collects but will only paste most recent item | Excel Discussion (Misc queries) | |||
Threaded Mode
