Kumar Shanmugam
Member
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.
Please find the attached file which contains raw data sheet and desired result sheet
Please find the attached file which contains raw data sheet and desired result sheet