Forum Discussion
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 the name of the column in a string in the Tags (G) column. However I need the names to have commas and ignore the boxes that do not have an x.
I also made another 8 columns to display the name of the column, instead of the x's, not sure which set of columns are easier to use? Thank you in advance.
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.
8 Replies
- 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=1Xfltu
Please attach a sample workbook without sensitive data, or make it available via OneDrive, Google Drive, Dropbox or similar.
- Here is a sample
https://1drv.ms/x/s!AhqfA3IMcQcWg7gJ4grwM5IgkMX9uQ?e=7AKxH7
