I am using the COUNTIF function in VBA to count the number of times numbers like 450032027446442502730 appear in a column. Unfortunately, COUNTIF seems to treat 450032027446442502730 exactly the same as a number that is the same apart from the last few digits. For instance WorksheetFunction.CountIf(ActiveSheet.Range("A1:A4"),"450032027446442502730") would return 4 rather than 3 where the values below populate cells A1 to A4.
450032027446442502730
450032027446442502730
450032027446442502745 (different last 2 digits)
450032027446442502730
If think this is because it interprets these numbers like 450032027446440000000 or something, treating the last however many digits as zeroes.
Hope this makes sense. Many thanks in advance.
Rowan
Bookmarks