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.

"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