Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help on formula
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 |