If the data is duplicate, then vlookup for the latest date of multiple data

Hi,

Say, there're multiple data randomly stored and trying to find the max data or latest date of the given data if data is duplicate.

For example,

A(Code) B(Date) C(Result)
1 AO4201 20140218 ?
2 AO4200 20140305 ?
3 AO4200 20140218 ?
4 AO4204 20140318 ?
5 AO4200 20140422 ?

> Find the Max value when the date is duplicate
* Condition 1, Data will be continuously added below column A and B
* Condition 2, It cannot change original data.

AO4200 -
AO4201 -
AO4204 -

>Expected result:
AO4200 - 20140422
AO4201 - n/a
AO4204 - n/a


To find the result, I tried to use the formula = If(countif(A1:B5,A1)>=2,Vlookup(A1,A1:B5,3,0),"n/a")

I looked it up other's query, and some of them used Max, but in this case, I do not know where to put MAX, since vlookup function only gets the first value.
Please help to solve it.

Thanks,
Nara

Hi,
look in my sample workbook, but in fact I used array formula:

Please Login or Register  to view this content.

Book1.xlsx

Hope it works also for you... =)

Regards

M