Finding Duplicates

T

TLT

I have a list..
505/1
505/2
505/3
I need to make sure that non of these numbers are duplicates of a master
list, I thought about something simple like:
=if(A1=z1:Z1000, "Duplicate").
This doesn't appear to work with a rang.

Can anyone help?
 
O

Ozzie via OfficeKB.com

TLT,

if you do a search for "Missing Sequential Numbers" and find my thread you
should find your answer. I did a similar thing last week but included
searching for missing sequential numbers as well. It may certainly point you
in the right direction.
 
R

Ron Coderre

Try something like this:

=IF(ISNUMBER(MATCH(A1,$Z$1:$Z$1000,0)),"duplicate","")

copy that formula down as far as you need

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top