+ Reply to Thread
Results 1 to 5 of 5

How to remove duplicate rows only if columns A and B are BOTH duplicates in Excel 2003

  1. #1
    Registered User
    Join Date
    03-10-2010
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    63

    How to remove duplicate rows only if columns A and B are BOTH duplicates in Excel 2003

    Greetings,

    I have a sheet with data in columns A and B. Its approx 2000 rows long. I need to remove the duplicate rows, but only if BOTH columns are duplicated. I need to leave the unique dates for each unit. I need to do it in VBA, and it needs to run in Excel 2003. In 2007 its easy to simply use the removeduplicates code, but it errors out in 2003.

    I need a module of code that will find all the duplicate rows in the worksheet, and simply delete the entire row.
    The Data looks like this:

    BLG109T 04-Jun-2012
    BLG109T 05-Jun-2012
    BLG109T 06-Jun-2012
    BLG109T 07-Jun-2012
    BLG109T 10-Jun-2012
    BLG109T 10-Jun-2012
    BLG111T 04-Jun-2012
    BLG111T 05-Jun-2012
    BLG111T 06-Jun-2012
    BLG111T 06-Jun-2012
    BLG111T 07-Jun-2012
    BLG111T 10-Jun-2012
    BLG127T 10-Jun-2012
    BLG127T 04-Jun-2012
    BLG127T 05-Jun-2012
    BLG127T 06-Jun-2012
    BLG127T 06-Jun-2012
    BLG127T 07-Jun-2012
    BLG128T 07-Jun-2012
    BLG128T 10-Jun-2012
    BLG128T 04-Jun-2012
    BLG128T 05-Jun-2012
    BLG128T 05-Jun-2012

    etc.

    Any help would be greatly appreciated.

    Regards,
    Chris

  2. #2
    Valued Forum Contributor Steffen Thomsen's Avatar
    Join Date
    10-15-2010
    Location
    Kolding, Denmark
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    953

    Re: How to remove duplicate rows only if columns A and B are BOTH duplicates in Excel 2003

    Hi,

    Try this

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-10-2010
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    63

    Re: How to remove duplicate rows only if columns A and B are BOTH duplicates in Excel 2003

    Hey,

    Thanks for the help, but I've tried that already. That code doesn't work in Excel 2003. I need something that works in 2003 as I'm locked into 2003 at work.

    Chris

  4. #4
    Forum Contributor
    Join Date
    01-20-2012
    Location
    Amsterdam, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    186

    Re: How to remove duplicate rows only if columns A and B are BOTH duplicates in Excel 2003

    Hi Benisato, try this:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-10-2010
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    63

    Re: How to remove duplicate rows only if columns A and B are BOTH duplicates in Excel 2003

    That worked perfectly! Thanks so much for the help

    Chris

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1