Results 1 to 4 of 4

Thread: Consolidating text cells

  1. #1
    Neophyte Jewels's Avatar
    Join Date
    Mar 2021
    Posts
    2
    Articles
    0
    Excel Version
    365 excel pro

    Consolidating text cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello, I'm trying to consolidate cells into one cell using a common identifier. I was looking for something like sumifs for text but I have not found anything but Concat which you manually have to add each cell and the number of cells can change. This is pulling into a bigger report and a pivot table would not be helpful. I've tried Ifsums, If, Match index and concat. Please help
    Attached Files Attached Files

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    317
    Articles
    0
    Excel Version
    2019
    Would a presentation as below be acceptable?

    Excel 2016 (Windows) 32 bit
    A
    B
    3
    Activity Measure
    4
    452957 Update 1 ,update 2 ,Update 3 ,Update 4
    5
    454050 Update 1
    6
    454423 Update 1 ,update 2 ,Update 3 ,Update 4 ,Update 5
    7
    454424 Update 1 ,update 2 ,Update 3
    Sheet: Sheet2


    Achieved in Power Pivot with Measure created using ConcatenateX
    Attached Files Attached Files
    Last edited by alansidman; 2021-03-09 at 08:55 AM.

  3. #3
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    317
    Articles
    0
    Excel Version
    2019
    Look at the last example in this link https://www.howtoexcel.org/tutorials...%20a%20formula

    Excel 2016 (Windows) 32 bit
    A
    B
    3
    Activity Measure
    4
    452957 Update 1
    update 2
    Update 3
    Update 4
    5
    454050 Update 1
    6
    454423 Update 1
    update 2
    Update 3
    Update 4
    Update 5
    7
    454424 Update 1
    update 2
    Update 3
    Sheet: Sheet2
    Attached Files Attached Files

  4. #4
    Neophyte Jewels's Avatar
    Join Date
    Mar 2021
    Posts
    2
    Articles
    0
    Excel Version
    365 excel pro
    yes it would!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •