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

"Peter" wrote:

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