format column for unique values only

K

KL

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
 
J

JohnLute

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...
 
Top