• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Doubt on how to highlight rows that have same account number but different customer names

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
 

Attachments

  • Doubtonexceldata.xlsx
    10.5 KB · Views: 0
Hi Kumar,
Welcome to the forum Chandoo.org...

See the attached if it is okay.

Regards,
 

Attachments

  • Doubtonexceldata.xlsx
    12.2 KB · Views: 0
Back
Top