Forum Discussion
Countif function
In my opinion column A strings are different. "256" <> "0256" <> "00256" <> "000256".
COUNTIF formula gave other result.
Any advice is appreciated
| A | B | C | |
| 1 | Code Text | Counter | Formula |
| 2 | 256 | 4 | =COUNTIF(A$2:A$5,A2) |
| 3 | 0256 | 4 | =COUNTIF(A$2:A$5,A3) |
| 4 | 00256 | 4 | =COUNTIF(A$2:A$5,A4) |
| 5 | 000256 | 4 | =COUNTIF(A$2:A$5,A5) |
Hi Liviu,
That's known issue, function converts text to numbers. Try
=COUNTIF($A$2:$A$5,CHAR(173)&A2)
I don't remember the source, it's already discussed here
Hi Liviu,
That's known issue, function converts text to numbers. Try
=COUNTIF($A$2:$A$5,CHAR(173)&A2)
I don't remember the source, it's already discussed here
