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 For...
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
