Forum Discussion
Solved
HELP!!!!!
I was wondering if anyone can help me? I have about 8 columns that have x's, if the item is about Christmas, Birthday, etc. I want to display the names of the columns that do contain x's with t...
crissitinka Perhaps the attached file works for you. It uses TEXTJOIN to create the tags in column D. Also, couldn't resist to change the formulae in columns F:X. No need to hard-code every category in the formula when you can just refer to the column header.
here is the link to my sheet https://1drv.ms/x/s!AhqfA3IMcQcWg7gJ4grwM5IgkMX9uQ?e=7AKxH7
crissitinka Perhaps the attached file works for you. It uses TEXTJOIN to create the tags in column D. Also, couldn't resist to change the formulae in columns F:X. No need to hard-code every category in the formula when you can just refer to the column header.
- Hi Riny Van Eekelen,
I am confused. I love the idea if I could just use the columns with the X's and the top of the column name. I see that the formula for the columns with the names and not the ones with the X's. Can you help me with the formula? This sheet is only being shared between you and I.
Christina
https://1drv.ms/x/s!AhqfA3IMcQcWg7gMOavhu2DUBGCU-A?e=1Xfltucrissitinka Yes you can. Use
=TEXTJOIN(", ",TRUE,FILTER($Y$1:$AR$1,Y2:AR2="x",""))in D2 and copy it down.