Re: $$Excel-Macros$$ Help: How to remove duplicate rows

2010-02-18 Thread janet dickson
Dave, these are not sample data thus why am want to remove them. But thanks for being curious. One Love as a group. On Thu, Feb 18, 2010 at 12:09 PM, Dave Bonallack wrote: > Hi Jen, > Sample data has no duplicates. Am I missing something? > Also, is the data allowed to be sorted? > Regards - Dav

RE: $$Excel-Macros$$ Help: How to remove duplicate rows

2010-02-18 Thread Dave Bonallack
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..

Re: $$Excel-Macros$$ Help: How to remove duplicate rows

2010-02-17 Thread ayush jain
Hi Jen, You may use the macro below to delete the duplicate rows.You may also use Excel 2007 'Remove Duplicate Rows ' Functionality. Do let us know if any further help is required. Public Sub DeleteDuplicateRows() ' ' This macro deletes duplicate rows in the selection. Duplicates are ' counted in