Problem with countif

[TooneTown]

I have used countif to check for duplicates for years without a problem. For some reason, it is not working now. Please see the image I uploaded. Here is the formula I used - =COUNTIF($K$5:$K$9610,K5). i then filtered on the number 32. If you look at the screen shot that I attached, you can see that all of the values in column K are different, yet countif gives the result of 32. This happened 4 times on this spreadsheet. The format for Column K is Text.

I don't understand why this formula is not working.

Any Help would be greatly appreciated.

Larry

 

[Fluff]

Hi & welcome to MrExcel.
The problem is that countif only looks at the first 15 significant characters.
Try sumproduct like

=SUMPRODUCT(--(K2:K7=K2))