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.
=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.