Hi,
I want to search column C, and hi-light all duplicate values. But I only want to compare cells which contain the character _
So if in C column , I have the following:
apple <-----(ignore this dupe)
dog
dog_a
cat
apple <----- (ignore this dupe)
cat_a
dog_a
I only want it to find dupes with _. Ignore any other dupes
I have this code which is not working. Nothing happens:
Please Login or Register to view this content.
Bookmarks