Re: Handling duplicates with their originals

Robert:
If I understand correctly you want to find duplicates while still showing both versions so you can decide which one need to be deleted, rather than just filtering uniques.
Try this:
First sort your data by the column that wil most likely place duplicate rows right on top of each other.

Create a column to the right (next to the one that will help you locate dupes), say next to names, or id number.
in the first cell of the new rowenter this formulary
=if(click cell to left=click cell under the last,"duplicate"," ")
then copy this formula all the way to the bottom of the new column.
This is a simple logic testing if the row in the column to the left is the same as the one right below it it will list dupe in the new column.
This basic formulary will tag your dupes so you can examine them and decide which one is best to delete.