Combine values in multiple cells by commas

**chandramouliarun** · 03-30-2021, 06:20 AM

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

**Bo_Ry** · 03-30-2021, 06:56 AM

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)

**ben8563** · 03-30-2021, 06:58 AM

Formula:

Please Login or Register  to view this content.

**KOKOSEK** · 03-30-2021, 07:02 AM

In Bo_ry formula, I suggest:

Formula:

Please Login or Register  to view this content.

Combine values in multiple cells by commas

LinkBack

Thread Tools

Rate This Thread

Display

Combine values in multiple cells by commas

Re: Combine values in multiple cells by commas

Re: Combine values in multiple cells by commas

Re: Combine values in multiple cells by commas

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Retun values from non blank cells and combine results from multiple cells

Lookup multiple values in a single cell (separated by commas) and then return the values

[SOLVED] Need to combine cells to one string of text if duplicate values exist in multiple cells

Returning Multiple Values Separated by Commas to a single cell

[SOLVED] Combine values from multiple cells into one cell, then delete duplicate lines

[SOLVED] How do I combine multiple lines of information into a single cell, separated by commas?

Combine Values of Multiple Cells in a Range

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions