Create a Pivot Table. For example:

type date
abc 12/3/2005
abc 6/7/2007
abc
def 10/26/2007
def 10/25/2007
def
ghj
ghj 12/12/2005
ghj 9/9/2007

will produce:

Min of date
type Total
abc 12/3/2005
def 10/25/2007
ghj 12/12/2005

--
Gary''s Student - gsnu200751


"Gwynneth" wrote:

I want to select the minium date in column B (excluding blanks) and subject
to matching a document type listed in Column A. How can I do this

A B
ABC 28/10/06
ABC 01/01/07
ABC
ABC 25/07/07
ADE 15/05/07
ADE
ADE 28/02/07


Desired Result (separate worksheet)
A B
ABC 28/10/06
ADC 28/02/07

Thanks

--
Gwyn