Compare 2 Excel Lists & Remove Duplicates

Remove items from a list that occur in another list

The option Compare 2 lists for matching entries is ideal for showing you which items appear in both lists, but does not remove them. The option Remove Entries from "List Range" that Occur in "List 2 Range" will do this in the blink of an eye.  As it creates a copy, your original 2 lists are left unchanged should you need them.    

This option is ideal for a large list or table of email addresses, names, items or anything!

Names 1 New has had all entries that also occur in Names 2 removed

Duplicates Manager Start > Duplication Manager Options: Create a list of unique data > Display only unique data > Create a summary report > Color code all duplicates, up to 3 levels > Prevent users from adding duplicates to a list or table > Compare 2 lists for matching entries > Remove duplicates from any range > Remove entries from one list that exist in the other > Remove duplicate rows from a table >  Leave only first occurrence of each duplicate entry > Fill blank cells within a list with data in the cell directly above

Excel Duplicate Manager $29.95 Excel 97 to 2003 versions. Payment Problems/Options 30 Day Money Back Guarantee & Big Discount for Unlimited License