I am trying to find duplicate values in an excel sheet from multiple columns (via VBA / Macros)
It works for the most part, however, there are a few ambiguities when I am doing a comparison between numeric values. Numbers need to be compared literally rather than the actual value.
Attached is an excel sheet.
Rows 2 and 4 are correctly identified as duplicates.
Rows 6 and 9 are WRONGLY identified as duplicates.
Rows 7 and 8 are CORRECTLY identified as NOT duplicates. When we have a some value in Column D (which may or may not contain any values)
Rows 10 and 11 are WRONGLY identified as duplicates inspite of having unique values (atleast on display)
Any help is appreciated to resolve the inconsistency.