Forum Discussion
Excel IF statement formatting request
Do you use comma as decimal separator? If so, the formula should be
=COUNTIF(A:A;A1)=1
for the entire column, or
=COUNTIF(A$3:A$53;A3)=1
for only the range A3:A53
Do you mean that you do not want to allow duplicates in column A?
If so: select column A. A1 should be the active cell in the selection.
On the Data tab of the ribbon, click Data Validation.
Select Custom in the Allow list.
Enter the following formula
=COUNTIF(A:A,A1)=1
Activate the Error Message tab.
If you wish, enter a message. This will be displayed if the user enters a duplicate value.
If you wanted something else, please explain in more detail.
Select A3:A52. A3 should be the active cell in the selection.
Perform the same steps as in my previous reply, but with the formula
=COUNTIF(A$3:A$52,A3)=1
Do you use comma as decimal separator? If so, the formula should be
=COUNTIF(A:A;A1)=1
for the entire column, or
=COUNTIF(A$3:A$53;A3)=1
for only the range A3:A53
- I tried to use the formula you provided but I cant enter other number or any number, also does it need to start with =, because it is not accepting when it is included.