+ Reply to Thread
Results 1 to 6 of 6

Summarize and concat cells

  1. #1
    Registered User
    Join Date
    03-08-2010
    Location
    Sweden
    MS-Off Ver
    MS Office 365 Mac and Windows
    Posts
    94

    Summarize and concat cells

    Hello forum experts!

    I have this problem that is time consuming doing manually.
    I need to summarize each unique "cost_level" and also get details from the pos and sum column into one cell with vba.
    I have attached a file where the data is and the expected result that I did manually (partly), hope it is understandable what I'm looking for.

    Thanks
    Regards
    Attached Files Attached Files
    Last edited by soreno; 05-14-2019 at 06:48 AM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: Summarize and concat cells

    Try
    Please Login or Register  to view this content.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: Summarize and concat cells

    1. Run the Macro PTnMore
    2. Run the UDF VlookupMulti with your cursor in cell I3: Thanks to Jindon for supplying this code ages ago.
    3. Copy I3 Down.
    4. The syntax for the UDF is in Cell J1

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Registered User
    Join Date
    03-08-2010
    Location
    Sweden
    MS-Off Ver
    MS Office 365 Mac and Windows
    Posts
    94

    Re: Summarize and concat cells

    Thanks, @ jindon all seems fine except the "sum_details", it picks from wrong column ("column B": sum) is ("column C": sum) instead.... where do you change to get the right column B?

    Ahh the first value picks the wrong column in a strange way, the rest of the data in cell "sum_detais" seems fine when looking at it closer...
    Last edited by soreno; 05-14-2019 at 06:42 AM.

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: Summarize and concat cells

    OOps, of course...
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    03-08-2010
    Location
    Sweden
    MS-Off Ver
    MS Office 365 Mac and Windows
    Posts
    94

    Re: Summarize and concat cells

    Exellent!!! Exactly what I needed

    Thanks a million!!

    Regards

+ 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. [SOLVED] Formula to concat cells together and then add new components in LEN is not 18
    By batexcel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2019, 05:20 AM
  2. CONCAT/TEXTJOIN on Variable Number of Cells
    By OlYeller21 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-10-2019, 06:29 AM
  3. trying to concat 2 cells in one DateTime value
    By acheo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2016, 06:41 PM
  4. Replies: 0
    Last Post: 06-05-2014, 10:45 AM
  5. Combine multiple cells in columns - Concat with variable spacing using VBA Script
    By AMC_CO in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2013, 03:57 PM
  6. [SOLVED] concat cells based on date range
    By DamianWarS in forum Excel General
    Replies: 8
    Last Post: 09-14-2012, 12:39 PM
  7. [SOLVED] Concat and summarize 6 columns to 2 columns
    By italia in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2005, 03:05 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