Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restrict cell value to unique value within column.
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restrict cell value to unique value within column.
From the ToolsOptions menu on the Edit tab, check the
"Enable AutoComplete for cell values" checkbox. Now, Excel will try to AutoFill the entry, such that if you have already typed "Jane Doe" somewhere in the list and you begin typing "Jan", it will attempt to fill in "Jane Doe". If that happens with the name you are trying to enter, press escape and go on to the next name. "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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restrict cell value to unique value within column.
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restrict cell value to unique value within column.
Less intrusive would be just to highlight the cell (see bottom of the post
for another suggestion) Select the column, with C1 as the active Cell In the menu to Format=Conditional Formatting Change Cell Value is to Formula is Enter a formula =Countif($C$1:C1,C1)1 click the format button and then select the patterns tab, select a color like Red then OK out of the dialogs. Now if you enter a duplicate value, the cell will turn red. You could do something similar with the Menu Data=Validation using the custom formula. This will put up an error message. -- Regards, Tom Ogilvy 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
Filer for unique records and return all column data for unique rec | Excel Discussion (Misc queries) | |||
I would like to copy UNIQUE data from a column in a SINGLE CELL | Excel Discussion (Misc queries) | |||
How can I restrict cell data display to column width? | Excel Discussion (Misc queries) | |||
Restrict Find to one column | Excel Programming |