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
