How to do partial match with FILTER function - Excel Tips and Tricks

Опубликовано: 13 Сентябрь 2024
на канале: Rabi Gurung

133

Discover how to do partial match with FILTER function in Excel.

The FILTER function in allows you to extract data based on specific criteria. In many cases, you may want to perform a partial match using FILTER, meaning you want to extract data that partially matches a certain word or phrase.

Formulas featured in the video.

Filter Partial Match String

Filter Commodity Name Containing "green"
Looking For=FILTER(A2:A76,ISNUMBER(SEARCH("green",A2:A76)))

Filter Commodity Name Containing "green" & "chilli"
=FILTER(A2:A76,ISNUMBER(SEARCH("green",A2:A76))*ISNUMBER(SEARCH("chilli",A2:A76)))

Filter Partial Match String (complete row)
=FILTER(A2:D76,ISNUMBER(SEARCH("green",A2:A76))*ISNUMBER(SEARCH("chilli",A2:A76)))