Chip Pearson has something that can help:
http://www.cpearson.com/excel/NoDupEntry.htm



pg23673 wrote:

I am entering unique serial no. in col A. Can I set up a rule which will not
allow a duplicate serial no. entry into another cell?

--

Dave Peterson