Re: $$Excel-Macros$$ FW: How to remove the duplicate value

Dear Neeraj, You can also use Data->Remove Duplicates in 2007 and Advance Filter to remove duplicate. with formula you can use.. =sumproduct(--($C$2:C2=c2)) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain

Re: $$Excel-Macros$$ FW: How to remove the duplicate value

Save file as an xlsM file and enable macros and use Option Explicit Sub nodupesperitemSAS() Dim i As Long For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1 If Cells(i, "d") = Cells(i - 1, "d") Then Rows(i - 1).Delete Next i End Sub From: Neeraj Chauhan Sent: Thursday, September 29, 2011 2