macro and/or functions

[Sue]

I have a table below that I want to only to see the materials with the last
purch date.
material purch date
A 1/2/2008
A 2/10/2007
A 2/12/2008
A 12/2/2006
A 3/23/2008
A 8/17/2007
B 1/2/2008
B 2/10/2007
B 2/12/2008
C 12/2/2006
C 3/23/2008
C 8/17/2007

 

[Don Guillett]

See other post. Pls post in only one group

 

[T. Valko]

Here's my best guess:

A2:A13 = mat code
B2:B13 = dates

E2:E4 = A, B, C

Enter this array formula** in F2 and copy down to F4:

=MAX(IF(A$2:A$13=E2,B$2:B$13))

Format as DATE

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

 

[Sue]

i couldnt tell if it worked on the first one. sorry bout that

 

[Don Guillett]

Mine worked