Delete duplicates based on criteria

**chrism_cfu** · 12-07-2012, 06:59 AM

Hi to all once again
I need your help once again

Sorry that I cannot attached an xl example but through corporate condition the only I can do is to copy paste from xl (if I am out of forum condition please delete this post)
I want to delete duplicates based on the following criteria.
I want to delete the row that appears one or more times in contract number column and have the same reason. In this case I want to delete the row with newest entry date.
In my example I want to delete only the first row

Thanks again for your valuable help

Entry date Customer's Last Nam Customer'sFirst Name Contract Number Contract reason
9/8/2012 christos m 002600015007794423 5007794423 contract
3/8/2012 christos m 002600015007794423 5007794423 contract
3/8/2012 evelyn e 20 6901735240 question
3/8/2012 peter p 21 6901735240 question
4/8/2012 James J 15 6 question
4/8/2012 James J 15 6 contract

**lmp** · 12-07-2012, 07:18 AM

Hello,

make a backup copy of your file.

Then go Data > Remove duplicates - specify the range that you want to check for duplicates.

By default, Excel will keep the first item and remove any duplicates further down. You may want to sort your data ascending by entry date, so the newest entry date duplicate will be deleted.