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?