schneitodd
New Member
- Joined
- Mar 18, 2003
- Messages
- 36
- Office Version
- 2016
- Platform
- Windows
I have a data file that has a column for each item that was "tagged." The tags are topics or locations, but are sorted alphabetically, and additional tags could be added in the future (so the column numbers might change).
I would like to have Excel scan the row for the noted locations (locations represented by yellow columns) and place the name of the location in a new column I've added (highlighted in blue). Every row should only have 1 location (yellow column) populated. I can generate a discrete list of locations if I need to compare each cell to a list.
I lack VBA skills and typically try to rely on nested functions, but I'm open on the approach and willing to learn.
I would like to have Excel scan the row for the noted locations (locations represented by yellow columns) and place the name of the location in a new column I've added (highlighted in blue). Every row should only have 1 location (yellow column) populated. I can generate a discrete list of locations if I need to compare each cell to a list.
I lack VBA skills and typically try to rely on nested functions, but I'm open on the approach and willing to learn.