Forum Discussion
Simple way to highlight near-duplicates
I would like to write a simple formula to highlight cells that are near-duplicates rather than exact duplicates. I would like to try this by entering a formula into the Conditional Formatting -> ...
there is no such simple solution and without more restraints i couldn't even start to propose a more complex solution. By your 'definition' it could match a single character to any other cell with that character in it.