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?

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.


TLT wrote:
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?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200602/1

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


"TLT" wrote:

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?