An issue with CountIF and the original data in the fields

[mimih23]

Hello!
I cannot for the life of me figure out why I am receiving an error for a simple CountIF formula. I have a total of 12663 items in Column A with duplicates and all I want is to count the number of duplicates for each. It works great for the majority but there are a few that the formula is reading as duplicates. There are no extra spaces, commas, apostrophes, etc. within these cells. Any suggestions. Here is what the formula is yielding:


0D9988 SSL 4
0D9988 SSL 4
0D9988 SSL 4
0D9988 SSL 4
0D9989 SSL 1
0D9990 SSL 1
0D9996 SSL 1
0E0002 SSL 53
0E0009 SSL 53
0E0015 SSL 53
0E0015 SSL 53
0E0017 SSL 53
0E0018 SSL 53
0E0018 SSL 53
0E0022 SSL 53
0E0022 SSL 53
0E0024 SSL 53
0E0034 SSL 53
0E0038 SSL 53
0E0045 SSL 53
0E0045 SSL 53
0E0045 SSL 53
0E0045 SSL 53
0E0045 SSL 53
0E0045 SSL 53
0E0045 SSL 53
0E0045 SSL 53
0E0049 SSL 53
0E0052 SSL 53
0E0057 SSL 53
0E0074 SSL 53
0E0077 SSL 53
0E0084 SSL 53
0E0093 SSL 53
0E0132 SSL 53
0E0132 SSL 53
0E0157 SSL 53
0E0176 SSL 53
0E0179 SSL 53
0E0188 SSL 53
0E0193 SSL 53
0E0200 SSL 53
0E0202 SSL 53
0E0202 SSL 53
0E0207 SSL 53
0E0212 SSL 53
0E0217 SSL 53
0E0228 SSL 53
0E0233 SSL 53
0E0233 SSL 53
0E0253 SSL 53
0E0258 SSL 53
0E0269 SSL 53
0E0271 SSL 53
0E0277 SSL 53
0E0281 SSL 53
0E0284 SSL 53
0E0286 SSL 53
0E0287 SSL 53
0E0297 SSL 53
0E0312 SSL 1
0E0314 SSL 1

As you can see, the formula (=CountIF(A:A,A:A) is working for all except the 53 items which are obviously not the same. Let me know if you have suggestions. The error message appears on all 53 items stating that "the number in this cell is formatted as text or preceded by an apostrophe." All of the items are formatted as text. To change the format to general or number would corrupt they are all alphanumeric. You can see that 0E0312 nor 0D9988 is affected by this. Help!!

 

[mimih23]

Oh my goodness......your name is fitting.....because that worked! Yeah!!!!!! Now I'll need to check my other data and continue with my more detailed analysis. Thank you so much! Now, I won't have to worry about this in the morning!!!!

 

[AlphaFrog]

Yep, yours is better Berry.