I forgot to say - you can copy the formula down in the normal way(s).

Pete

On Jul 25, 8:09*pm, Pete_UK wrote:
Try this array* formula in B2 of Sheet2:

=MIN(IF((Sheet1!A2:A100=A2),Sheet1!B2:B100,10E10))

* Array formulae need to be committed using the key combiation Ctrl-
Shift-Enter (CSE) instead of the usual <enter. If you do this
correctly then Excel will wrap curly braces { } around the formula
when viewed in the formula bar - do not type these yoruself. Use CSE
again if you subsequently edit or amend the formula.

Hope this helps.

Pete

On Jul 25, 7:51*pm, dcr wrote:



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!- Hide quoted text -

- Show quoted text -