+ Reply to Thread
Results 1 to 6 of 6

How do I combine duplicate entries and add numbers?

  1. 08-10-2022, 11:20 AM #1
    zachwalkerpinto
    zachwalkerpinto is offline
    Registered User
    Join Date
    06-13-2022
    Location
    Albany, NY
    MS-Off Ver
    Windows 10
    Posts
    12

    How do I combine duplicate entries and add numbers?

    I have the following table.

    I wish to combine duplicate entries and add the # column between them. For instance, there are three "Customer 2, Product A" entries shown below. I would like to change this to one single "Customer 2, Product A" entry with 35 as its # feature.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-10-2022, 11:45 AM #2
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: How do I combine duplicate entries and add numbers?

    A pivot table is probably the easiest. https://www.excel-easy.com/data-****...ot-tables.html
    You could also use a SUMIFS() function: https://support.microsoft.com/en-us/...6-611cebce642b

    Let us know if you have trouble implementing either of those.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  3. 08-10-2022, 12:19 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: How do I combine duplicate entries and add numbers?

    What version of Excel are you using?
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 08-10-2022, 12:41 PM #4
    zachwalkerpinto
    zachwalkerpinto is offline
    Registered User
    Join Date
    06-13-2022
    Location
    Albany, NY
    MS-Off Ver
    Windows 10
    Posts
    12

    Re: How do I combine duplicate entries and add numbers?

    Hi TMS, I am using Excel for MS 365
    Reply With QuoteRegister To Reply
  5. 08-10-2022, 02:09 PM #5
    Limor_OP
    Limor_OP is offline
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: How do I combine duplicate entries and add numbers?

    E2
    =UNIQUE(Table1[[Account]:[Category]])

    G2
    =SUMIFS(Table1['#],Table1[Account],E2,Table1[Category],F2)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 08-10-2022, 02:24 PM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How do I combine duplicate entries and add numbers?

    With a pivot table.

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    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] Combine data from rows of duplicate id numbers
    By JanetS in forum Excel General
    Replies: 11
    Last Post: 08-25-2016, 05:00 PM
  2. [SOLVED] Stocklist - Combine Duplicate entries, Delete rows
    By ibs2012 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2013, 05:56 AM
  3. Prevent Duplicate Entries in a Pulldown List from a Column with Duplicate Entries
    By carleaston in forum Excel General
    Replies: 0
    Last Post: 06-14-2012, 12:38 PM
  4. [SOLVED] Parse data and combine values for duplicate entries for the same date
    By rlaserra in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2012, 10:27 PM
  5. check a list of numbers for duplicate entries in Excel
    By Space in forum Excel General
    Replies: 3
    Last Post: 08-15-2006, 12:55 PM
  6. how can I check a worksheet for duplicate entries or numbers?
    By RFI in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2005, 12:05 AM
  7. Can I compare 2 lists to combine duplicate entries in new list?
    By Tinytall in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-13-2005, 01:06 PM

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