You can use the Data Validation tool to do this. See
http://www.cpearson.com/excel/nodupentry.htm for details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"Hobbieman" wrote in message
...
I am trying to create a spreadsheet which contains names of people in
column C.

I would like to configure the spreadsheet, so that as I enter names
into the cells in column C, excel gives me an error if the name being
entered already exists in another cell in Column C.

Anyone know how to do that?