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!
Last edited by marreco; 05-31-2012 at 06:26 AM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks