How to avoid duplicate string value input in one column?

  • Thread starter Thread starter Wavelet
  • Start date Start date
W

Wavelet

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
 
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 Data>Validation
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter Unique values from Duplicates 6
Complex search and replace macro based on input variables. 12
Augmenting an integer in a column to reflect duplicates in another 23
help with formula for last input in column 6
how to avoid duplicate entries in column 1
Duplicate Values in Excel 2007 6
How to assign unique number to column duplicates? 3
Returning row and column headers of a value 3

Back
Top