Excellent! Thank you very much!
--
www.Marzetti.com
"KL" wrote:
Hi John,
Assuming the column is [A], try selecting the entire column, got to menu
DataValidation, in the dropdown box select 'Custom' and write the following
formula in the formula box:
=COUNTIF(A:A,A1)=1
Regards,
KL
"JohnLute" wrote in message
...
How can I format a column so that it only accepts unique values?
Thanks!
--
www.Marzetti.com