•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Returning column headings that have the lookup value of Y
I have a list of accounts that have various criteria columns with Y or N in them. I've created a lookup tab in the file to make it easier for someone to types in the account number and they know some specifics about it. What I want to do is have it list all the columns where there is a Y and state what the column is in a top down list. Thanks for any help!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#lookup
#Y
#N
#accounts
#columns
#criteria
#account number
#list
#criteria columns
#file
#top down list
#function
#headings