Have a Question?

If you have any question you can ask below or enter what you are looking for!



Code for Remove duplicate

I am working on Excel and there are 2 columns and i want to merge them and want to remove duplicate values so that i can get the unique counts.

For Example, i have columns(First_Name and Last_Name) if there is any person comes twice in the list, it should be removed from the list.

Thanks in advance.

  pankaj

This is nice and easiest question there is one liner code for it. Let's say you want to remove duplicate values but there is no limit of number of rows so you have to find last row and then you can use below mentioned code to remove duplicates.

lrow_dup_chk = Sheets("Dup_Chk").Range(Cells(Rows.Count, 1).Address).End(xlUp).Row

 ActiveSheet.Range("$B$1:$B$" & lrow_dup_chk).RemoveDuplicates Columns:=1, Header:= _
        xlYes



  Devbrat Tripathi       22 Aug 2016       2       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any