Brian from Maui
MrExcel MVP
- Joined
- Feb 16, 2002
- Messages
- 8,459
Aloha,
I am using a this conditional format to locate dupe names:
=countif($1$99,b1)>1
If there is any extra spaces etc. Excel will not recognize this as a match. Is there a way where I can tweak this formula to also find like names, or names with transposed letters or extra space between the first and last name?
Brian
I am using a this conditional format to locate dupe names:
=countif($1$99,b1)>1
If there is any extra spaces etc. Excel will not recognize this as a match. Is there a way where I can tweak this formula to also find like names, or names with transposed letters or extra space between the first and last name?
Brian