+ Reply to Thread
Results 1 to 6 of 6

Sum Duplicate Rows

  1. 06-30-2018, 08:37 AM #1
    hftechno
    hftechno is offline
    Forum Contributor
    Join Date
    10-04-2014
    Location
    USA
    MS-Off Ver
    MS Office 2013
    Posts
    146

    Sum Duplicate Rows

    Trying to sum rows based upon Column H value.
    Example attached. Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-30-2018, 09:06 AM #2
    SjonR
    SjonR is offline
    Forum Contributor
    Join Date
    05-12-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    266

    Re: Sum Duplicate Rows

    use a Pivot-table
    Reply With QuoteRegister To Reply
  3. 06-30-2018, 09:15 AM #3
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Sum Duplicate Rows

    vba
    Please Login or Register  to view this content.
    Last edited by jindon; 06-30-2018 at 09:37 AM.
    Reply With QuoteRegister To Reply
  4. 06-30-2018, 09:53 AM #4
    ikboy
    ikboy is offline
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: Sum Duplicate Rows

    try this:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 06-30-2018, 10:08 AM #5
    hftechno
    hftechno is offline
    Forum Contributor
    Join Date
    10-04-2014
    Location
    USA
    MS-Off Ver
    MS Office 2013
    Posts
    146

    Re: Sum Duplicate Rows

    thanks jindon!
    Reply With QuoteRegister To Reply
  6. 06-30-2018, 10:12 AM #6
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Sum Duplicate Rows

    You are welcome and thanks for the rep.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    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. [SOLVED] Search for duplicate entries but keep duplicate rows and add entry accordingly
    By GreenWheels in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2017, 06:13 PM
  2. Add values from duplicate rows and delete duplicate
    By jane204 in forum Excel General
    Replies: 3
    Last Post: 11-20-2016, 08:36 AM
  3. Merge Duplicate Rows unique values into single rows for an infinite amount of columns/rows
    By aimeecrystalaid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2013, 08:43 PM
  4. [SOLVED] Delete rows based on duplicate cell, but leaving first and last duplicate.
    By LadyNicole in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2013, 05:07 AM
  5. VBA helps needed to Sum duplicate values and delete duplicate rows
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2013, 11:40 PM
  6. 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
  7. [SOLVED] Conditional formatting of duplicate rows (not duplicate cells)
    By ExcelStefan in forum Excel General
    Replies: 2
    Last Post: 06-19-2012, 06:09 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