formatting columns

[Chris Shearman]

Is there a way to format a column so that no number ever repeats? So if a
3rd party is entering an ID number, and it already exists, it won't let
them...

 

[Ragdyer]

Check out this web page of Chip Pearson:

http://www.cpearson.com/excel/NoDupEntry.htm