How do I set up an Excel column to not allow duplicate entries (m.

Staci2s · Jun 2, 2005

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!

Duke Carey · Jun 2, 2005

Chip Pearson's site explains how to do that:

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

Staci2s · Jun 2, 2005

Wow! Thanks for the speedy reply. Got it all figured out!