I am working on an assignment and I have downloaded a rather large amount of data from multiple data sources. There are numerous duplicates in my dataset because each data source contains at least one datapoint that matches the datapoint of another source. A simple conditional format and search for duplicates would usually suffice. However, many of my data sources include an instance of their name in parenthesis at the end of each datapoint. The following is an example of my data:

Name Source Value **Does it find the duplicate**
Volvo AutosLTD $53,000 -------
Volvo (Cars.com) Cars.com $53,000 NO
Volvo (Auto Digest) Auto Digest $53,000 NO
Volvo Wheels $52,999 YES

In the above example, a conditional format highlighting the duplicate values would only find one of the three duplicate values.

I figured that I could simply do a Find by looking in Values and then Replace what I found with a blank. And after doing so, my table would look like as such:

Name Source Value
Volvo AutosLTD $53,000
Volvo Cars.com $53,000
Volvo Auto Digest $53,000
Volvo Wheels $52,999

But when I run a conditional format to highlight the duplicate values, Excel still does not pick up on these duplicates. I have made sure to only highlight only the one row I am interested in (Name) when I ran the conditional format. I don't know what's preventing Excel from highlighting the duplicate values. If I simply retype, say Volvo, underneath the entry I just made a change to (Find (Cars.com) & Replace with a blank), then the entry I just typed is highlighted but the one I made a change to is not.

Does anyone have any suggestions/comment? Any help would be greatly appreciated. Thanks.