View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
 
Posts: 493
Default Restrict cell value to unique value within column.

Look he

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

In article ,
Hobbieman wrote:

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?