Results 1 to 8 of 8

Combining several duplicate rows, summing one column, and removing original duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    10-12-2012
    Location
    Portland
    MS-Off Ver
    Excel 2003
    Posts
    8

    Combining several duplicate rows, summing one column, and removing original duplicates

    Hi. There are several threads on this forum with similar keywords (e.g., this one) but they do not have exactly what I need.

    I am looking to simply de-dupe the rows that are repeated -- duplicates being recognized based on two columns and then if the rows are duplicate, folding them into one row but with "Qty" column being incremented.

    Attached is a simple example. In this file:

    1. Duplicates are recognized by two columns: Title (C) + Images (E). Currently there may be duplicate rows with exactly the same value across these two columns, each row having Quantity (column M) as 1.

    2. I want to merge these separate rows into unique rows, and correspondingly increment the Qty column based on how many original duplicate rows existed.

    3. These de-duped rows should be in a new worksheet.

    Just FYI, I am on Excel on Mac 2011 -- latest version 14.2.3, which can run exactly the same macros and VB functions as Windows. Would appreciate any pointers or function writing help.

    Thanks!
    Attached Files Attached Files
    Last edited by pkiula; 10-12-2012 at 08:55 PM.

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