Countif returns an incorrect value

[dfpquality]

I have a list of Serial Numbers (17 characters that can be either numeric or alpha-numeric). I've "filtered" the list for unique values and place those in another column. In another column I use the expression =COUNTIF($K$2:$K$414,O2) .....For all numeric serial numbers, it returns a value of "10". Can anyone explain this phenomenon?

 

[Andrew Poulsom]

Can we see some sample data please? COUNTIF doesn't distinguish between text and numbers.

 

[dfpquality]

Hi Andrew,

I don't post here often (as you can see), so if you can tell me how to attach data or something here, I'd gladly provide that to you. This issue is driving me CRAZY!

Best Regards,
Keith

 

[Aladin Akyurek]

Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste for posting a sample.