If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Help on formula" <Help on wrote in
message ...
I have list of two columns A=Addresses and B=Dates. In addresses column
some
addresses are duplicated (because the date is different). I want the most
resent dated address merge into one address. In other words of explaining
is
to avoid the duplication of the same address, I want to keep the most
resent
dated address on the list. Please help me with the formula so instead of
deleting the duplicated addresses manually by checking the recent dates
(which is very time consuming and inaccurate process) I can simply apply
the
formula. Thank in advance