Most recent receipt date for an item

[Pierre]

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

 

[Max]

In Sheet2,

With unique part numbers in A2 down

In B2, array-entered**:
=MAX(IF(Sheet1!$A$2:$A$100=A2,Sheet1!$B$2:$B$100))
Format B2 as date, copy down
ADapt the ranges to suit

**Press CTRL+SHIFT+ENTER to confirm the formula
instead of just pressing ENTER

 

[Pierre]

In Sheet2,

With unique part numbers in A2 down

In B2, array-entered**:
=MAX(IF(Sheet1!$A$2:$A$100=A2,Sheet1!$B$2:$B$100))
Format B2 as date, copy down
ADapt the ranges to suit

**Press CTRL+SHIFT+ENTER to confirm the formula
instead of just pressing ENTER

Max,
looks great and works like a charm. Thanks much.
Pierre

 

[Max]

Good to hear that, Pierre.
Thanks for feeding back.