+ Reply to Thread
Results 1 to 5 of 5

How to remove unique rows (macro)?

  1. 02-04-2011, 01:51 PM #1
    davidparkes
    davidparkes is offline
    Registered User
    Join Date
    10-08-2010
    Location
    MK, UK
    MS-Off Ver
    Excel 2003
    Posts
    70

    How to remove unique rows (macro)?

    Hi

    Could this code be changed to remove all uniue rows? currently when it's run it leaves some unique values behind

    example book attached.

    Cheers
    David
    Attached Files Attached Files
    Last edited by davidparkes; 02-04-2011 at 03:26 PM.
    Reply With QuoteRegister To Reply
  2. 02-04-2011, 02:07 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to remove unique rows (macro)?

    David,

    You need a header row above your data, and I made a correction to the code in the other thread.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 02-04-2011, 03:14 PM #3
    davidparkes
    davidparkes is offline
    Registered User
    Join Date
    10-08-2010
    Location
    MK, UK
    MS-Off Ver
    Excel 2003
    Posts
    70

    Re: How to remove unique rows (macro)?

    Hi

    Thanks for that , which code did you update ?

    I think there are three differnt ones on thatthread.

    Cheers
    Reply With QuoteRegister To Reply
  4. 02-04-2011, 03:17 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to remove unique rows (macro)?

    The only code I posted in the thread: http://www.excelforum.com/2465067-post5.html
    Reply With QuoteRegister To Reply
  5. 02-04-2011, 03:26 PM #5
    davidparkes
    davidparkes is offline
    Registered User
    Join Date
    10-08-2010
    Location
    MK, UK
    MS-Off Ver
    Excel 2003
    Posts
    70

    Re: How to remove unique rows (macro)?

    Thanks very much, perfect

    Cheers
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1