| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format a column | Excel Discussion (Misc queries) | |||
| look up same values in coumn1 and calculate values in 2nd column | Excel Worksheet Functions | |||
| Changing format of column from "general" to "currency" | Excel Discussion (Misc queries) | |||
| Column Chart with 2 values in each column | Charts and Charting in Excel | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
Hybrid Mode
