Delete duplicates based on DATES.

Hi.

Delete duplicates based on DATES.

If I have dates in column "B" I want to make only the most recent date, the rest of the data will be deleted.


Column "A" is where the dates and in the "B" have duplicates.
example:
DD / mm / yyy
Column "A" - Column "B"
15/04/2012---Laranja
25/04/2012---Laranja
06/05/2012---Laranja
01/04/2012---Laranja

the result would be
06/05/2012---Laranja because it is the most recent date of duplicate data

Thank you!

sort by column a descending then use remove duplicates feature on col b

the problem is that I have many rows of data.
the example that I have left is the dummy sentences.

I have many columns and many rows
the code would help me a lot, please help me, thank you!

how is your data actually laid out then?

I have data in column "A" to Column "D" with over 10,000 lines

that's not what i asked,how many columns have dates,how many columns have names with duplicates ? you could just record a macro doing what i suggested above,(but really its only a few clicks (10)to remove dupes manually if its just 2 columns as your example manually) but no one can guess exactly what you want ,post a sample workbook.

heres a recorded macro i tidied up a bit to run on sheet 1

Please Login or Register  to view this content.

Hi.

Greate, thank you!!!