I have two columns for name and corresponding address. I need to find the duplicates of both columns as one (eg. There may be two John Smiths, but if their addresses are different, they're two unique people. On the other hand, if there is a third John Smith entry that repeats one of the original addresses, it must be a duplicate, and has to be deleted.) I want to find a way to easily find and delete duplicates, where I can sort out the [duplicates minus 1 entry that has to be left over], and delete them.
Solved by M. H. in 28 mins