+ Reply to Thread
Results 1 to 4 of 4

Combine values in multiple cells by commas

  1. #1
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    180

    Red face Combine values in multiple cells by commas

    Hi All,

    Hope you are doing well!...I am trying to combine the values in multiple cells by commas with reference to the same set of ctextid,vbillid and claimid ..The column to combine using commas is the proccode column ..Can you please help me here...Attached the excel sheet with the input and output tabs...





    Thanks,
    Arun
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    5,776

    Re: Combine values in multiple cells by commas

    Please try at
    A2
    =UNIQUE(Input!A2:C13)

    D2
    =TEXTJOIN(",",,FILTER(Input!$D$2:$D$13,MMULT(--(Input!$A$2:$C$13=A2:C2),{1;1;1})))

    E2
    =XLOOKUP(TRUE,MMULT(--(Input!$A$2:$C$13=A2:C2),{1;1;1})>0,Input!$E$2:$F$13)
    Attached Files Attached Files
    Last edited by Bo_Ry; 03-30-2021 at 07:18 AM. Reason: Forgot to Locked cell

  3. #3
    Registered User
    Join Date
    03-28-2021
    Location
    China
    MS-Off Ver
    2019
    Posts
    25

    Re: Combine values in multiple cells by commas

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,042

    Re: Combine values in multiple cells by commas

    In Bo_ry formula, I suggest:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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] Retun values from non blank cells and combine results from multiple cells
    By Alabina25 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-17-2019, 05:10 AM
  2. Replies: 3
    Last Post: 03-10-2017, 07:56 PM
  3. [SOLVED] Need to combine cells to one string of text if duplicate values exist in multiple cells
    By Chris McGlothen in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-17-2017, 09:13 PM
  4. Returning Multiple Values Separated by Commas to a single cell
    By enragedpigeon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2015, 05:48 PM
  5. [SOLVED] Combine values from multiple cells into one cell, then delete duplicate lines
    By Ocean Zhang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2015, 07:01 PM
  6. [SOLVED] How do I combine multiple lines of information into a single cell, separated by commas?
    By ilostar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2012, 11:48 AM
  7. Combine Values of Multiple Cells in a Range
    By PY_ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2011, 08:54 AM

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