| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to avoid duplicate string value input in one column?
Hi,
I want to set a constraint on one excel column so that when the input is duplicate with other column, excel sheet will refuse to accept. It's string type. Does anyone know how to implement it in excel 2003? Thanks, --Wavelet |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to avoid duplicate string value input in one column?
Use data validation
Assume you want to restrict entry into column A if column B already contains the value Select column A Goto the menu DataValidation Select Custom Formula: =COUNTIF(B:B,A1)=0 OK out Note that a user can still copy/paste or drag-n-drop a restricted value into column A. Biff "Wavelet" wrote in message oups.com... Hi, I want to set a constraint on one excel column so that when the input is duplicate with other column, excel sheet will refuse to accept. It's string type. Does anyone know how to implement it in excel 2003? Thanks, --Wavelet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| avoid duplicate names in legend | Charts and Charting in Excel | |||
| i maintain DB of URLs in Excel. how can i avoid duplicate entry? | Excel Worksheet Functions | |||
| Avoid duplicate number entry when only start and stop numbers given. | Excel Discussion (Misc queries) | |||
| How to avoid duplicate characters if only typed once? | Excel Worksheet Functions | |||
| How can I avoid circular reference AND extra input | New Users to Excel | |||
Linear Mode
