Forum Discussion
Solved
Can I use wildcards with the new FILTER function
I want to be able to filter a list that contains cells with lengthy text strings in them such as "12:15 to 12:35 Meeting with (Sponsor 1) at table (2) (Delegate Request)". I want to create a new lis...
Perhaps the attached file helps you find a solution. It combines FILTER with a SEARCH for the text string in the larger text.
Thank you
Since February 2022, there is a solution for filtering and using wildcards.
Look here:
https://hermann-baum.de/excel/hbSort/en/xlookup.php#XVW2fi
Greetings
Hermann