S
shirley_kee
Data is as follows:
A1 099
A2 99
A3 099
A4 99
The cells are all formatted as TEXT
In A5 is a formula =COUNTIF(A1:A4, A1)
The result incorrectly calculates to 4 not 2 which is what I woul
rather see.
Has anybody experienced this anomoly and how do I force COUNTIF t
evaluate the "literal text cell values" rather than a "numeri
conversion of the cell values" which appears to be happening
A1 099
A2 99
A3 099
A4 99
The cells are all formatted as TEXT
In A5 is a formula =COUNTIF(A1:A4, A1)
The result incorrectly calculates to 4 not 2 which is what I woul
rather see.
Has anybody experienced this anomoly and how do I force COUNTIF t
evaluate the "literal text cell values" rather than a "numeri
conversion of the cell values" which appears to be happening