|
format column for unique values only
|
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 |
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 |
| All times are GMT +1. The time now is 06:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com