+ Reply to Thread
Results 1 to 2 of 2

How to consolidate duplicate rows and sum their values automatically?

  1. #1
    Registered User
    Join Date
    07-03-2010
    Location
    Lithuania
    MS-Off Ver
    Excel 2016
    Posts
    83

    How to consolidate duplicate rows and sum their values automatically?

    Hello,
    How to consolidate duplicate rows and sum their values automatically, via formula?
    Capture.PNG
    Attached Files Attached Files
    Last edited by rcurious; 05-28-2020 at 04:45 AM.

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,833

    Re: How to consolidate duplicate rows and sum their values automatically?

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    in E2 Ctrl+Shift + Enter
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    in F2 and drag it down
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Consolidate duplicate rows based on upper/lowercase
    By Windbrand in forum Excel General
    Replies: 5
    Last Post: 03-17-2017, 12:21 AM
  2. Replies: 2
    Last Post: 12-09-2016, 01:47 AM
  3. [SOLVED] Consolidate rows with duplicate entries into one row based on some conditions...
    By lifeisaspreadsheet in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 11-04-2012, 12:24 PM
  4. [SOLVED] Consolidate rows with duplicate ID number into one row
    By BME_Guy in forum Excel General
    Replies: 5
    Last Post: 10-22-2012, 09:11 PM
  5. Help: Consolidate duplicate rows in different tables with one varying column
    By g1987 in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2012, 02:03 PM
  6. [SOLVED] Help: Consolidate duplicate rows with one varying column
    By g1987 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2012, 12:23 PM
  7. Consolidate Duplicate Rows into One Cell
    By Aeoneye in forum Excel General
    Replies: 10
    Last Post: 04-07-2011, 01:13 PM

Tags for this Thread

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