I am using CountIF VBA version which gives me ease due to its fast calculation while working with the large datasets. My Data has text values as well as numerice values so it is basicaly a combination of different values.
I just want to count the number of repeated values but my function is giving wrong result as you can see in attached file.
I would appreciate if someoene can look into it and make it more efficent in terms of:
Accurate count for repeated values
and the last thing is i want to use this code in Personal.XLSB so i can recall it using shortkey.
I hope to get help. Thanks