Forum Discussion

gjrotondaro's avatar
gjrotondaro
Copper Contributor
Jun 13, 2024

Duplicate Values that are not exact match

Hello,

 

I have an excel file with names I need to clean up. I started with using conditional formatting to highlight all duplicate values and deleted the duplicates. There are still duplicates in the file that don't share the exact name. For example, there's one cell called "Blackline Safety", and another called "Blackline Safety Corp". These are duplicates, but I don't know how to do it without looking manually. Is there any way to get excel to find the duplicates like that?

 

Thanks

Resources