Hi,

You may try the following in sheet 1.

In the first row (say A3), enterthe following array formula (Ctrl+Shift+Enter)

=if(or(exact(A3,range in sheet 2))

Regards,


"Carter68" wrote:

I have 2 worksheets with names and addresses. Is there a way to check to see
if any of the names on worksheet 2 are duplicated from worksheet 1. If so,
is there a way to indicate which of these are duplicates? Name would be in
Column A and Address would be in Column 2.

Thanks!