Lookup MIN Date
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 -
|