Handling duplicates with their originals

[RSmith123]

I need to be able to take 2 lists, identify the matches and delete them, along with the original listing so that all is left are rows that did not match any other records.

In other words, I am using one list to filter another with the unmatched results remaining.

Can you help me do this?
Thanks
Robert

[skybrake]

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.

[DigDB Support]

This is exactly what the table match feature is for. Take a look at this demo http://digdb.com/excel_add_ins/duplicates_find_remove_dedupe/ - go through Example1 and Example2.