Countif function

[Liviu Muscalu live_outlook]

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)

[#2 · Accepted solution]

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

[#3]

Tks

[#4]

@Sergei Baklan

Source: Daily Dose Of Excel