+ Reply to Thread
Results 1 to 4 of 4

Adding quantities in column C if data in column A and column B are identical

  1. #1
    Registered User
    Join Date
    09-14-2012
    Location
    Netherlands Rotterdam
    MS-Off Ver
    Excel 2010
    Posts
    9

    Adding quantities in column C if data in column A and column B are identical

    This request is related to a warehouse situation.

    I looking for a way to add ( make a total of) the quanties in column C providing that the item numbers listed in column A and the location numbers in Column C are identical.

    Preferably the items and the locations that have been added together are deleted in column A and B. So just the total of the item in the specific location stays.

    Please see attachment.

    Since the orginal file is thousands of lines, you help is very much appreciated.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    7,835

    Re: Adding quantities in column C if data in column A and column B are identical

    One of options: formula in D4:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and copy all the way down (double click on filling handle). Select column D, copy it and Paste Special as values.
    Now filter whole range on column D equal "delete" and delete visible rows.
    Disable filter and only summarized rows will remain.
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    09-14-2012
    Location
    Netherlands Rotterdam
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Adding quantities in column C if data in column A and column B are identical

    Perfect Kaper, exactly what I needed.

    Thank you very much for your help!

    Kind regards
    Peter27

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    7,835

    Re: Adding quantities in column C if data in column A and column B are identical

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively not active member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. Replies: 1
    Last Post: 04-12-2019, 08:15 PM
  2. Merge identical cells in one column, adding corresponding values in next
    By Fishdisease in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-03-2016, 08:49 AM
  3. [SOLVED] Expand on Parse Function/ Column to Column - Contiguous Data to include quantities
    By arcamp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2013, 05:18 PM
  4. Help for adding static date in column B on import/pasting of data in Column A
    By Parijaat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2013, 05:34 AM
  5. Replies: 4
    Last Post: 10-31-2011, 04:33 PM
  6. compare 2 sheets on one identical column and update another column
    By ashland in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-11-2011, 04:00 PM
  7. Replies: 2
    Last Post: 07-20-2009, 08:52 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1