Hi I wanted to know excel formula and function that highlight rows that have same account number but different names. I don't want to highlight rows that have same account number and same customer name. I want to highlight rows that have got same account number but different names.
For eg those highlighted in red in attached file.
Doubt.JPG
Bookmarks