Hi Jen, Sample data has no duplicates. Am I missing something? Also, is the data allowed to be sorted? Regards - Dave.
Date: Wed, 17 Feb 2010 23:12:00 +0300 Subject: $$Excel-Macros$$ Help: How to remove duplicate rows From: janetdicks...@gmail.com To: excel-macros@googlegroups.com Hello Fans.. Am in trouble, please give a macro to remove duplicate rows (attached file show just few data) this will help me alot (My original data have up to 6100 rows, possibly more than 500 rows are duplicate). Regards Jen -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _________________________________________________________________ Link all your email accounts and social updates with Hotmail. Find out now http://windowslive.ninemsn.com.au/oneinbox?ocid=T162MSN05A0710G -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
