Unique values per column in EXCEL.

How can get EXCEL to validate that input values in a column are unique?

Thanks,

Jeff
jwstairsAsked:
Who is Participating?
 
tureCommented:
Jeff,

To Allow only unique values in column A, do this:

1. Select column A
2. Data - Validation
3. Allow: Custom
   Formula: =COUNTIF(A:A,A1)=1
4. Click "OK"

Ture Magnusson
Karlstad, Sweden
0
 
nfernandCommented:
Recorcocholis Batman.... nice answer Ture.
0
 
jwstairsAuthor Commented:
Many thanks.  I knew it could be done but I'm sure I wouldn't have found that.

Jeff

Brussels, Belgium
0
 
tureCommented:
You are welcome, Jeff! I'm glad that I could help you with this.

/Ture
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.