Solved

Unique values per column in EXCEL.

Posted on 2001-08-30
4
499 Views
Last Modified: 2006-11-17
How can get EXCEL to validate that input values in a column are unique?

Thanks,

Jeff
0
Comment
Question by:jwstairs
  • 2
4 Comments
 
LVL 22

Accepted Solution

by:
ture earned 100 total points
Comment Utility
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
 
LVL 2

Expert Comment

by:nfernand
Comment Utility
Recorcocholis Batman.... nice answer Ture.
0
 

Author Comment

by:jwstairs
Comment Utility
Many thanks.  I knew it could be done but I'm sure I wouldn't have found that.

Jeff

Brussels, Belgium
0
 
LVL 22

Expert Comment

by:ture
Comment Utility
You are welcome, Jeff! I'm glad that I could help you with this.

/Ture
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Article by: dandraka
There are several quick shortcuts that can make your life easier in Microsoft Programs.  These simple tips and tricks will your work more productive and you faster at completing your tasks! MS Word (1) Creating Re-usable Scraps You can create s…
Outlook Free & Paid Tools
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now