CountIf() comparison only looks at first 15 characters
Posted on 2012-08-17
I am trying to use the countif() function to detect duplicate records in an Excel 2007 worksheet. The criteria I need the function to evaluate is a string of 23 characters (all numbers, no text).
The problem I am having is that the comparison used by countif() only looks at the first 15 characters in the criteria expression. For example the countif function considers the 2 strings 1234567890123451 and 1234567890123452
to be equal..
Is there some workaround for this? Or maybe a more robust function?