Thread: Lookup MIN Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dcr dcr is offline
external usenet poster
 
Posts: 5
Default Lookup MIN Date

I have inherited a spreadsheet with a formula that does not work. Instead of
returning the earliest order date it returns the first order date. I would
like a formula to place in Sheet 2 that would populate the earliest order
date.

Sheet 1

Part Number Order Date
111 9/10/2007
113 1/1/2007
111 1/1/2007
113 2/1/2002

Sheet 2

Part Number Earliest Order Date
111 1/1/2007
113 2/1/2002

Thank you in advance!