I have a column of IDs and I want to check if there are duplicates in this column as I loop through it.
However, I need to ignore suffixes to the data.
e.g.
Can I use CountIfs for this?Code:123 - false
124 - true
124 - true
125 - true (matches 125_1 and 125_2)
125_1 - true (matches 125 and 125_2)
125_2 - true (matches 125 and 125_1)
126_1 - true (matches 126_2)
126_2 - true (matches 126_1)
127 - false
Or maybe multiple CountIf's.
I'm concerned that if I have to write it myself in VBA it wont be as efficient as the built in functions
