+ Reply to Thread
Results 1 to 5 of 5

Macro to find duplicate values in a column and add the corresponding rows

  1. 09-25-2013, 05:01 AM #1
    hoss88 is offline
    Registered User
    Join Date
    11-13-2012
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    77

    Macro to find duplicate values in a column and add the corresponding rows

    Hi

    I would like a macro to find duplicate values in a column and add the corresponding rows. Please see attached excel file showing the details, the 2nd sheet shows the expected results.

    Thank you in advance.
    Hoss
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-25-2013, 05:07 AM #2
    OllieB is offline
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Macro to find duplicate values in a column and add the corresponding rows

    Do you also want to remove the blank rows left behind by the merge operation? For example should row 17 on the expected results worksheet be deleted?
    If you like my contribution click the star icon!
    Reply With QuoteRegister To Reply
  3. 09-25-2013, 05:13 AM #3
    hoss88 is offline
    Registered User
    Join Date
    11-13-2012
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    77

    Re: Macro to find duplicate values in a column and add the corresponding rows

    Hi OllieB
    No the rows should stay as they have values in other columns which are used. lease also note that the duplicate column (Ba) containing 0 are not deleted.

    thanks
    Hoss
    Reply With QuoteRegister To Reply
  4. 09-25-2013, 05:26 AM #4
    OllieB is offline
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Macro to find duplicate values in a column and add the corresponding rows

    Ok, have a go with the attached workbook
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 09-25-2013, 05:40 AM #5
    hoss88 is offline
    Registered User
    Join Date
    11-13-2012
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    77

    Re: Macro to find duplicate values in a column and add the corresponding rows

    Absolutely amazing - thank you very much - works perfectly.

    Hoss
    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)

Similar Threads

  1. Remove rows with duplicate values in one column based on value of another column
    By jolleyje in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2013, 06:20 AM
  2. [SOLVED] macro to find same largest values in a column and delete all other rows..help required!!
    By gokzee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2012, 11:34 PM
  3. Scan rows for duplicate column values, then add rows together and delete unused rows.
    By bnasty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-12-2012, 08:38 PM
  4. VBA code to find duplicate values within multiple rows and columns
    By pcbpinoy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2011, 09:04 PM
  5. [SOLVED] Find unique duplicate values in rows
    By Bay in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-03-2011, 10:52 AM

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