Chip Pearson's site explains how to do that:

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



"Staci2s" wrote:

I'd like to make sure a user can't enter duplicate data into a particualar
column in an excel spreadsheet. Any help is REALLY appreciated!