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