• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 510
  • Last Modified:

Unique values per column in EXCEL.

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

Thanks,

Jeff
0
jwstairs
Asked:
jwstairs
  • 2
1 Solution
 
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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now