Problem while removing duplicate value using VBA

vinoth124

New member
Joined
Jun 21, 2014
Messages
1
Reaction score
0
Points
0
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.
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
You don't need VBA, just add a formula of

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

and copy down.
 
Top