validation column

B

benny

Hi all,
I have a problem to make validation to prevent duplication value in column.
Suppose I have arrays of data in column A (Employee ID) that contains
values, i want to no duplication value when i entering new data. If i
entered the same value as previous row then error message should be alert.

Any body can help what should the formula function applied. Thanks in
advance.

cheers.
 
B

Bob Umlas

Select all of column A. Assuming A1 is active, use Data/Validation, Select
Custom, enter =COUNTIF(A:A,A1)=1 then put in your error message.
Bob Umlas
Excel MVP
 

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

Conditional validation? 9
Looking formula that SUM values with specific value in neighboring colum 2
custom data validation on cells with data validation values 2
Excel 2010 - Custom Validation - Cell must contain another cells contents 0
Show a message if there are some duplicates 1
Data Validation using ISBLANK with non-contigious cells 2
unique key in an excel 2007 table 5
countif in Data Validation stops working? 3

Top