Chip Pearson has some techniques at:
http://www.cpearson.com/excel/duplicat.htm

Andrew wrote:

I am typing list of numbers in columns, none of the numbers can be
duplicated. Due to this I would like to set Excel up so that it can check
automatically. How do I do this????

--

Dave Peterson