Check for Duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 >Data>Filter 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:
 
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,
 
Back
Top