LARGE IF Statement?

[ScottyLawrenceCO]

I have a CSV data base that has hundreds of entries of transactions.

Column A is a 6 digit customer ID number.
Column B is the date that the transaction happened.
Column C is the price of the transaction.

On a seperate sheet, I have a space to type in a 6 digit customer ID. If you type in that number, I need a formula that will find the date of the transaction that customer had. So if you type in customer 123456 into cell A1, B1 would say, "2/21/2011" if that was the last time that customer made a purchase. If you type in 654321, cell B1 would change to "1/15/2011" since that was the last time THAT customer made a purchase.

Essentially I need to find the HIGHEST date in Column B, but taking into account the unique IDs in column A. If a LARGEIF() statement existed I would think it would do the trick (find the largest number IF that number has the same customer ID).

Please help!

 

[Haseeb Avarakkan]

Hi,

Welcome to the MrExcel,

Try this Array Formula, must hit Control+Shift+Enter, not just Enter.

=MAX(IF(Sheet1!A2:A1000=A1,Sheet1!B2:B1000))

 

[ScottyLawrenceCO]

Thanks for the welcome and the solution! I tried something similar but it wasn't working until i entered it as an array. I still don't really understand what that means, but it worked so we are in business.

Thanks!