I am trying to run a macro in excel that will find each instance of ‘X’ in a given row, and then return the Column Headers for each ‘X’ found.
If the following is an example of my table, then what I would like to accomplish is selecting ‘Tool 2’ from a drop-down, and listing out ‘Job1, Job3, Job5’ somewhere
| Job 1 | Job 2 | Job 3 | Job 4 | Job 5 | |
|---|---|---|---|---|---|
| Tool 1 | X | X | |||
| Tool 2 | X | X | X | ||
| Tool 3 | X | X |
I tried the FILTER option and an XLOOKUP, but functions don’t seem to be the way to go. So I’m taking a shot at a Macro, however I am not very versed in macros.
New contributor
PoopCat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.