This will remove the duplicates. If you have xl2007 you could use the remove duplicates
Sub advancedfilterunique()
lr = Cells(Rows.Count, 1).End(xlUp).Row
With Range("A1:A49")
.AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("b1"), Unique:=True
.Delete Shift:=xlUp
End With
Columns(1).Delete
Columns(1).AutoFit
End Sub
From: Suman
Sent: Thursday, September 29, 2011 1:27 AM
To: [email protected]
Subject: Re: $$Excel-Macros$$ find doubling
Hi, Anil
Please find the attached sheet if it helps you.
On Thu, Sep 29, 2011 at 10:54 AM, anil kumar <[email protected]> wrote:
Hello sir,
frist of all thanks for reply. I used your formula but it is not work
according to my data. I have attched that file. plz see that.
Thanks & Regards
Anil
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
«•´`•.(*•.¸(`•.¸*¸.•´)¸.•*).•´`•»
«´¨*•.¸¸.*.....~*--Suman --*~......*.¸¸.•*¨`»
«•´`•.(¸.•´(¸.• * •.¸)`•.¸).•´`•»
Mob: +91 9810333884
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<<A_html_m691da4f3.gif>>
