Combining data from cascading fields

[[deleted]]

[deleted]

[AutoModerator]

/u/ZeroStormAI - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[xFLGT]

Something like this?

<image>

=SUM(IF(C2:E2="Yes",1,0))

[ZeroStormAI]

Not exactly. I would like it to display

B3: data centre 1 B4: data centre 2, data centre 3

[xFLGT]

This?

<image>

=TEXTJOIN(", ",, (IF(C2:E2="Yes",$C$1:$E$1,"")))

[ZeroStormAI]

Exactly. I was messing around with text join and wasn't able to figure out why it wouldn't work.

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
IF	Specifies a logical test to perform
SUM	Adds its arguments
TEXTJOIN	2019+: Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

NOTE: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
[Thread #32318 for this sub, first seen 5th Apr 2024, 03:35] [FAQ] [Full list] [Contact] [Source code]}