Forum Discussion
How to find duplicate that is only contained partially in a cell
Hi, I'm aware of the Conditional Formatting that highlights duplicate values, however, how can I have excel find the duplicates within a partial cell? For example, if I am trying to find du...
I have attached a sample workbook with some dummy data, a helper column and a custom VBA function.
Select Conditional Formatting > Manage Rules... > Edit Rule to view the conditional formatting rule.
Press Alt+F11 to activate the Visual Basic Editor and to view the code of the function.
You'll have to allow macros when you open the workbook.
Thank you kindly Hans for your time to create this excel!
