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.
You could use Conditional Formatting with this formula...
=AND(FIND("_",A1),COUNTIF(A:A,A1)>1)
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
How exactly do I do this? I made a rule and used that formula, then added a "find duplicates" rule after it. didnt do anything....
Just select column A then make a rule with that formula. Don't need to make a find duplicates rule. It works for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks