LinkBack URL
About LinkBacks
I am looking for a function that once I select criteria (column headers) that filter column data. Blue table is dynamic table, Green is where I select the column names, and purple is my desired output..
I am looking for a function that once I select criteria (column headers) that filter column data. Blue table is dynamic table, Green is where I select the column names, and purple is my desired output..
Clear EVERYTHING from K1 to L7, then in K1 and ENTER:
=FILTER(Data[[#All],[Support Coordinator]:[Supervisor]],ISNUMBER(SEARCH(Data[[#Headers],[Support Coordinator]:[Supervisor]],TEXTJOIN(" ",,Table2[Select Column names]))))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Another optionFormula:
Please Login or Register to view this content.
thanks but criteria could change. So if I add "Region" in Select Column Names table, filter should pull that column as well.....
This, then:
=FILTER(Data[#All],ISNUMBER(SEARCH(Data[#Headers],TEXTJOIN(" ",,Table2[Select Column names]))))
The formula I suggested already does that.Originally Posted by KerahJoy
that worked....thank you!
thanks Fluff13
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks