How to remove duplicates based on two columns

column 1 has names
column 2 has dates

The end result I am looking for is that each person should NOT have duplicate dates. For example...

Joe has two entries for 11/15/2017, there should only be one entry for this.

Mike has two entries for 10/09/2017, there should only be one entry for this.

Lucy has two entries for 02/05/2017, there should only be one entry for this ... etc...

Keep in mind this is just a sample file I created, my real file (which I do not have yet) will have many many names and tons of different dates. So I dont think a forumla referencing the actual names would work.

Thank you

*file attached

Which is more important, the name or the date?

You can try a formula (see attached) you can Copy all Non 0's to another location OR Conditional formatting.

Originally Posted by kvsrinivasamurthy

ARRAY formulas (Confirm with Ctrl+Shift+Enter keys together)
IN I7, then drag across to collum J.

=IFERROR(INDEX(C$7:C$18,SMALL(IF(ISERROR(MATCH($C$7:$C$18&$D$7:$D$18,$I$6:$I6&$J$6:$J6,0)),ROW($C$7:$C$18),""),1)-ROW($C$6)),"")

Thank you, looks like it did the trick but I am trying to follow what you did. Are you saying to go in column I and drag to column J? I tried that and its just a blank cell, I do not see anything happening.

@tfiske - I think the name would be the driving factor for the date.