Multiple lists

P

Peter

Hi,

I got two (2) excel list with business contacts (company, adress, phone etc).
The isssue is that I need to "wash" the lists so that every duplicate is
marked, with a color or just so I can separate them from one another.
I know that this is possible, but how :) ?

Txh in advance
 
D

Duke Carey

In Excel 2007, use the "Remove Duplicates" option on the Data tab.

In earlier versions, combine a copy of each list into one big table, then
use Data->Filter->Advanced Filter->Copy to New Location->Unique Records Only
 
T

Toppers

Any simple "washing" will only work if the "duplicates" (fields to be
matched) are identical so it may be more complex than at first sight. Even
an embedded blank will result in a mismatch.
 
Top