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