JohnClifford
New Member
- Joined
- Jun 15, 2011
- Messages
- 7
Hi there.
I know it's possible to set up filters for cells containing a specified substring, but what I'm trying to do is slightly more complex and I'm not even sure if it's possible.
Basically I'm wondering if there's a way to add "tags" to a given Excel cell, but show them separately in an autofilter and show any row containing tag X when it's chosen in the autofilter. For example:
Say I have a cell with the tags FCS, RAC and SSI. I want to have them all listed separately in a filter and show that cell whichever tag is chosen for the filter. So if FCS, RAC or SSI are chosen the cell will show, but not if any other tag is chosen.
Is there a way to do this?
I know it's possible to set up filters for cells containing a specified substring, but what I'm trying to do is slightly more complex and I'm not even sure if it's possible.
Basically I'm wondering if there's a way to add "tags" to a given Excel cell, but show them separately in an autofilter and show any row containing tag X when it's chosen in the autofilter. For example:
Say I have a cell with the tags FCS, RAC and SSI. I want to have them all listed separately in a filter and show that cell whichever tag is chosen for the filter. So if FCS, RAC or SSI are chosen the cell will show, but not if any other tag is chosen.
Is there a way to do this?
