format column for unique values only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I format a column so that it only accepts unique values?

Thanks!
 
Hi John,

Assuming the column is [A], try selecting the entire column, got to menu
Data>Validation, in the dropdown box select 'Custom' and write the following
formula in the formula box:

=COUNTIF(A:A,A1)=1

Regards,
KL
 
Excellent! Thank you very much!

--
www.Marzetti.com


KL said:
Hi John,

Assuming the column is [A], try selecting the entire column, got to menu
Data>Validation, in the dropdown box select 'Custom' and write the following
formula in the formula box:

=COUNTIF(A:A,A1)=1

Regards,
KL


JohnLute said:
How can I format a column so that it only accepts unique values?

Thanks!
Click to expand...
Click to expand...
 
You must log in or register to reply here.

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

How to filter Unique values from Duplicates 6
Return the value from one range that does not exist in another 0
Count Unique Values in 1 Column based on Date Range in another Column 28
Count Unique Values 4
count unique values in one column for a set value in another col. 2
Unique Values Only 13
How to assign unique number to column duplicates? 3
function to only show unique cells in range (e.g. B2:B20) 6

Back
Top