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!

You could use FINDNEXT (look in vba help) within a for/each in the range
loop.

--
Don Guillett
SalesAid Software

"Carter68" wrote in message
...
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!

Carter --
Here's a two-step process. Someone else will chime in with something far
more elegant.

A B C
1 ABC ABC formula here
2 DEF ABD
3 GHI
4 JKL

=countif($a$1:$a$4,b1)

then copy down. Once that's done you can use DataFilter to display just
the lines that have something other than a '0' in column C.

HTH. Kind of brute force, but it works.
Here's the formula you put in C1:


"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!

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!