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

Most recent receipt date for an item
 

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Pierre" wrote in message
...
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

Most recent receipt date for an item
 

On Feb 8, 4:20*pm, "Max" wrote:
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
Singaporehttp://savefile.com/projects/236895
xdemechanik


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

Most recent receipt date for an item
 

Good to hear that, Pierre.
Thanks for feeding back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Pierre" wrote
Max,
looks great and works like a charm. Thanks much.
Pierre