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 - |
All times are GMT +1. The time now is 10:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com