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.
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
https://1drv.ms/x/s!AhqfA3IMcQcWg7gJ4grwM5IgkMX9uQ?e=7AKxH7