You can use Data Validation for this. Chip Pearson has instructions on
his web site:

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


Deler9 wrote:
I am using Excel and am trying to create a database that will check for
duplicate field entries and/or records. Help?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html