+ Reply to Thread
Results 1 to 2 of 2

How to collect values having duplicate records into single row?

  1. #1
    Registered User
    Join Date
    11-09-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    5

    How to collect values having duplicate records into single row?

    For example:

    A B

    100 10
    100 15
    100 12
    200 30
    300 21
    300 20
    400 17

    I want the above list to produce the below output: (values in column B added up for same values in A)

    100 37
    200 30
    300 41
    400 17

    Thanks in advance for the help guys....

    Tabraiz.

  2. #2
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    686

    Re: How to collect values having duplicate records into single row?

    Use Data > Filter > Advanced Filter to get a list of unique item from Column A

    Then use SUMIF

    you could place =SUMIF(A$1:A$7,A1,B$1:B$7) into C1 and copy down but you'll get 100 37 listed 3 times

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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