Dec 28 2021 05:55 AM
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 duplicate value "12345", I know excel can find this if another cell says "12345", but I want excel to find this from this third cell "ABC 12345 XYZ". So excel needs to search for this partial match.
How can this be done?
Thanks,
Amy
Dec 28 2021 06:02 AM
If one cell contains "12345" and another contains "56789", should they be highlighted since both have a "5"?
Same question for "Excel" and "PowerPoint", since both have an "e".
Dec 29 2021 04:31 PM
Dec 30 2021 03:02 AM
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.
Jan 01 2022 05:44 PM