Forum Discussion
Solved
Filter a table with wildcards based on a different cell not within the table
Good morning! I'm trying to create a scenario where I can filter my table based on a data-validated cell that is not within the table. Is there a way to do this? See attached for sample dataset. Than...
=FILTER($A$7:$F$13,NOT(ISNUMBER(SEARCH($A$3,$F$7:$F$13,1))))
This formula works in my Excel online spreadsheet.
How do you achieve it with the filter function? I'd like to stay away from macros just because this will be uploaded to a SharePoint and SP doesn't like macro-enabled workbooks. Thank you!
=FILTER($A$7:$F$13,NOT(ISNUMBER(SEARCH($A$3,$F$7:$F$13,1))))
This formula works in my Excel online spreadsheet.
- Ahh, it creates a new table, I see. Is there any way to have the cell referenced filter the current table? I have a gantt chart connected to the data so the end goal is to have the name filter the table which shows a gantt for that person.
Unfortunately i can't suggest a solution to filter the current table according to the selection of the dropdown cell (without creating a new table). But i wonder if it's possible to link the gantt chart to the new filtered table.