Forum Discussion
How to highlight cells where there are 2 or more words the same (ie a name)
Hi If i had a cell with Miss Campbell and Miss Campbell I want Excel to highlight that cell as I am checking the accuracy of the data it is pulling Thanks Sarah
Is this searching specific names
my interpretation of patick's formula is that it is taking the FIRST word from the string and seeing if THAT word is in the whole string at least 2x. So with "Dave Smith and Sue Booker and Dave Moon" it would find "Dave" and then see if "Dave ... Dave" exists in the string and in this case would reply true because "Dave" is in there 2x.