Forum Discussion

CodyC1015's avatar
CodyC1015
Copper Contributor
Dec 28, 2021
Solved

Copying TEXT from Columns into Cells (Separated by Commas)

Hi there, I'm looking for the easiest way to fill-in column e with the text in column a (separated by commas) IF they equal the value in column B. See screenshot for visual. Is there a formula that ...
excel
Formulas and Functions
office 365
  • HansVogelaar's avatar
    HansVogelaar
    Dec 28, 2021

    CodyC1015 

    If you have Office 2021 or Microsoft 365, in E2:

     

    =TEXTJOIN(", ",TRUE,FILTER($A$2:$A$16,$B$2:$B$16=D2))

     

    If you have Office 2019, in E2 confirmed with Ctrl+Shift+Enter:

     

    =TEXTJOIN(", ",TRUE,IF($B$2:$B$16=D2,$A$2:$A$16,""))

     

    These can be filled down from E2.

Resources