Re: $$Excel-Macros$$ Query (Remove duplicate)

Hi Karan, Try Advanced filter and select Unique records..And you can Copy and paste it in New Column.. [image: Inline image 1] *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Mon, Mar 19, 2012 at 1:07 PM, Karan Singh wrote: >

Re: $$Excel-Macros$$ Query (Remove duplicate)

Dear Karan, Please use below code.. Dim i, j As Integer Application.ScreenUpdating = False For i = 1 To Range("A65536").End(xlUp).Row For j = 1 To Range("B65536").End(xlUp).Row If Range("A" & i).Value = Range("B" & j).Value Then Range("B" & j).Delete Shift:=xlUp End If Next j Next i Application.S

Re: $$Excel-Macros$$ Query (Remove duplicate)

Go to data- remove duplicates Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: Karan Singh Sender: excel-macros@googlegroups.com Date: Mon, 19 Mar 2012 13:07:52 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query (Remove duplicate) Dear