Results 1 to 2 of 2

Thread: Problem while removing duplicate value using VBA

  1. #1

    Question Problem while removing duplicate value using VBA



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Friends,

    Request you kindly help me on the below issue. My excel contain 5 column like Name, Employee number, Age, mark, Grade. I need a VBA code to populate an error message when more than one row contains the same Name and emplyee number (only these 2 columns). I was not able to complete it. Requesting your help on this. Thanks.

  2. #2
    You don't need VBA, just add a formula of

    =IF(COUNTIFS($A:$A,$A2,$B:$B,B2)>1,"Duplicate,"")

    and copy down.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •