peiyezhuBronze ContributorSep 23, 2023Re: Filter function with a range as a criterium.https://techcommunity.microsoft.com/t5/excel/need-to-search-multiple-words-in-a-cell-and-get-the-output-based/m-p/2490856/page/3