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