Keep all cells in a column unique? No cells identical

P

phillr

Hello. I'm creating a video catalogue list. Each video is being assigned a
unique ID number. Column A is my ID # column. Is it possible to keep every
cell in Column A unique? If so, what would Excel do if I inputted two
identical cell values?

I'm using Excel 2002. Thanks!
 
G

Gary''s Student

Click on A1 and:

Data > Validation > Settings > Custom > Formula
=COUNTIF(A:A,A1)<2

Then copy A1 down as far as you need
 

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

Isolate UNIQUE combination of Z cells from a range N that adds up 3
Count Unique Values in 1 Column based on Date Range in another Column 28
count unique values with auto-filter on 6
Average Unique 7
Count Unique accross mulitple columns 3
Identical Cells in Multiple Worksheets in one Workbook. 4
Excel Pivot Table - Counting Unique Values within one column of da 1
Repeat formula for all cells in whole column 1

Top