Badgers2823
New Member
- Joined
- Jul 30, 2015
- Messages
- 1
Hi everyone,
I have a pretty large database for which I'm trying to write a function. For each row in my database, there are numerous columns that each row item is "tagged too." However, not all of the columns are showing, because they are grouped together (and you have to expand all groups to see all columns).
What I'm trying to do is write a function that will check all columns for each specific row, and then deliver the title (the top cell in each column) of each column that the particular row is tagged too (rather than toggle through all groups, a rather time-consuming process). Each row is tagged to numerous columns, and are tagged with a "Y" or "M" in the cell to indicate. The columns that aren't tagged are either blank or have an "N" in the cell.
I've tried using the IF, VLOOKUP and MATCH INDEX functions, but cannot seem to figure out a solution. I've listed the problems I've encountered below.
1. Delivering the column title vs. the content in the cell (ie in VLOOKUP, it will give the info from the cell)
2. Delivering results for all columns for each row, rather than the first column the function comes across and only that column.
3. How to pick up columns with both "Y" and "M" in them, without including those with "N" in them.
I have an example but don't believe I can post an attachment (and haven't quite figured out the HTML Maker). I'm using Excel 2013 and Windows 8.1. I'm not sure if I've given enough context so please let me know if you need more information. Any help would be greatly appreciated, thanks!
I have a pretty large database for which I'm trying to write a function. For each row in my database, there are numerous columns that each row item is "tagged too." However, not all of the columns are showing, because they are grouped together (and you have to expand all groups to see all columns).
What I'm trying to do is write a function that will check all columns for each specific row, and then deliver the title (the top cell in each column) of each column that the particular row is tagged too (rather than toggle through all groups, a rather time-consuming process). Each row is tagged to numerous columns, and are tagged with a "Y" or "M" in the cell to indicate. The columns that aren't tagged are either blank or have an "N" in the cell.
I've tried using the IF, VLOOKUP and MATCH INDEX functions, but cannot seem to figure out a solution. I've listed the problems I've encountered below.
1. Delivering the column title vs. the content in the cell (ie in VLOOKUP, it will give the info from the cell)
2. Delivering results for all columns for each row, rather than the first column the function comes across and only that column.
3. How to pick up columns with both "Y" and "M" in them, without including those with "N" in them.
I have an example but don't believe I can post an attachment (and haven't quite figured out the HTML Maker). I'm using Excel 2013 and Windows 8.1. I'm not sure if I've given enough context so please let me know if you need more information. Any help would be greatly appreciated, thanks!
