Check for Duplicates
 

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!

Check for Duplicates
 

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!

Check for Duplicates
 

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!

Check for Duplicates
 

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!