1

I am trying to come up with a formula that will return values of headers for each row that has one more more "x". (As seen in the "results" column below)
Can this be done without use of VBA or other external scripts?

t1 t2 t3 results
a x x t1,t2
b x x x t1,t2,t3
c x t3

Example Image

Improve this question
1
  • 1
    Welcome! You can try something like as {=TEXTJOIN(",";1;IF($B2:$D2="";"";$B$1:$D$1))}
    – JohnSUN
    Commented May 31, 2023 at 5:14

1 Answer 1

Reset to default
1

Try this formula:

=TEXTJOIN(",",,IF($B2:$D2="x",$B$1:$D$1,""))

enter image description here

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .