Mar 25 2022 05:03 AM
I would like to know if you an provide me a IF formula for the restriction of A1 to to other cell - restriction for example A1-1 the next should not put number 1 to the A2, possible as well to put a formula for the whole file and not for single cell only.
Referencen number for the chat 1037151891.
Mar 25 2022 05:13 AM
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.
Mar 25 2022 07:51 AM
Mar 25 2022 08:03 AM
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
Mar 25 2022 09:42 AM
Mar 25 2022 09:52 AM
SolutionDo 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
Mar 25 2022 10:19 AM
Mar 25 2022 09:52 AM
SolutionDo 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