Finding latest date

[tbaskar]

ABC Date ABC LATEST DATE
1 01/01/2013 15 09/01/2013
2 02/01/2013 5 05/01/2013
5 03/01/2013
3 04/01/2013
5 05/01/2013
6 06/01/2013
15 07/01/2013
8 08/01/2013
15 09/01/2013
8 10/01/2013

If I have data in column ABC and date in next column. If I enter next column ABC latest date to be appear in next column. I need formula please experts.,,,

LATEST DATE.xlsx

[:) Sixthsense :)]

In E2 cell

Please Login or Register  to view this content.

Drag it down...

[tbaskar]

Hi Sixthsence ,

U really amazing. Thank you,

Baskar

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback

[tbaskar]

Hi ,

Can u tell me how u doing =LOOKUP(2,1/(A:A=D2),B:B); 2,1/ meaning? If u like to share... Thanks.

[:) Sixthsense :)]

Please refer Post #16 of the below link for explanation
http://www.excelforum.com/excel-form...y-look-up.html