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.
In the attached file you can select the name which should be excluded and then click the button in cell E2 to start the macro. With Office365 or 2021 you can use FILTER function as well.
- 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.
