macro and/or functions
 

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

--
Sue

macro and/or functions
 

See other post. Pls post in only one group

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sue" wrote in message
...
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

--
Sue

macro and/or functions
 

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)


--
Biff
Microsoft Excel MVP


"Sue" wrote in message
...
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

--
Sue

macro and/or functions
 

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


"Don Guillett" wrote:

See other post. Pls post in only one group

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sue" wrote in message
...
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

--
Sue

macro and/or functions
 

Mine worked


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sue" wrote in message
...
i couldnt tell if it worked on the first one. sorry bout that
--
Sue


"Don Guillett" wrote:

See other post. Pls post in only one group

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sue" wrote in message
...
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

--
Sue