Yes....Use Elkar's version of the validation formula:
=countif(A:A,A1)=1

That should solve that problem.

Just be aware that the validation prevents the second instance of a
Stock Number. Consequently, before you can put a duplicate in its
proper place, you'd need to clear any previous instances.

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=481999