Find First Order Date

[detriez]

Win 7 (64)
Excel 2007


I have a workheet with the following columns
(Column A)=AccountName, (Column B)=OrderNumber, (Column C)=OrderDate

One AccountName can have multiple OrderNumbers and OrderDates

I would like to find the first order date for each AccountName and populate (Column D)=FirstOrderDate



TIA

 

[jmthompson]

You could use subtotals...
Sort by account number

Subtotal- at each change in account number, Min Order Date

 

[Aladin Akyurek]

Win 7 (64)
Excel 2007


I have a workheet with the following columns
(Column A)=AccountName, (Column B)=OrderNumber, (Column C)=OrderDate

One AccountName can have multiple OrderNumbers and OrderDates

I would like to find the first order date for each AccountName and populate (Column D)=FirstOrderDate



TIA

=INDEX(Sheet1!$C$2:$C$100,MATCH(A2,Sheet1!$A$2:$A$100,0))

where C2:C100 houses account dates on Sheet1 and A2:A100 account names, while A2 on Sheet2 houses an account name of interest.

 

[detriez]

Aladin...
Index and match was the answer.. I kept fighting with VLOOKUP

Thank you for the help

 

[Aladin Akyurek]

Aladin...
Index and match was the answer.. I kept fighting with VLOOKUP

Thank you for the help

You are welcome. Thanks for providing feedback.