Forum Discussion
Solved
Excel IF statement formatting request
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 ...
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
Perfect. What should I do if I wanted to apply the same criteria for cells A3 to A52?
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
- Perfect, I solved. Thank you very much
- 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.