View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gwynneth Gwynneth is offline
external usenet poster
 
Posts: 6
Default How can I find the minium date in column B subject to data in Colu

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