Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup the date associated with a given value | Excel Discussion (Misc queries) | |||
This should be easy - date lookup | Excel Discussion (Misc queries) | |||
Lookup/Date Question | Excel Worksheet Functions | |||
sum, lookup, and date range | Excel Worksheet Functions | |||
Lookup a date between other dates | Excel Worksheet Functions |