VBA Find Duplicates in Range to 2 Decimal Places and Highlight Both

[klight20]

Hello!

I have a range of data C:BV filled with numerical values to the 5th decimal place.

I would like a macro that finds duplicates in each column to the 2nd decimal place. So if I have 72.35854 and in the same column 72.35337, I want those to count as duplicates because they match to the second decimal. But I still want the numbers to the 5th decimal place to be shown.

Then I want to them both to be highlighted.

When I search, I find a code for highlighting duplicates, but not according to a decimal place. Can it be done?

Thanks in advance!

 

[Rijnsent]

Hi klight,
what code did you find? Adding some FLOOR() comparison to it should do the trick, so please post your code here, so someone can show you how to change it. Please, do put your code in [CODE][/CODE] brackets.
Cheers,
Koen