Forum Discussion
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 ...
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.
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.
