View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gavin Gavin is offline
external usenet poster
 
Posts: 21
Default Formula to Lookup Min value

Hi,

I have some data in the following format:

Ref Date
001 01/05/08
002a 10/05/08
002b 08/05/08
002c 12/05/08

I'd like a formula to use in another table that looks up anything with a ref
starting 002 and returns the earliest date (08/05/08).

Any help gratefully appreciated.

Thanks,
Gavin.