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. Thank you all!
=FILTER($A$7:$F$13,NOT(ISNUMBER(SEARCH($A$3,$F$7:$F$13,1))))
This formula works in my Excel online spreadsheet.
5 Replies
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.
