duplicate numbers

[Matt]

If there a formula to stop duplicate numbers any where in a sheet


Thanks in advance

 

[J.E. McGimpsey]

Take a look here:

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