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

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)))



How do I match partial data in Excel?,How do I filter if a partial text contains in Excel?,How do I partial match numbers in Excel?,How do I find the partial match between two columns in Excel?,
filter function with wildcard excel,excel filter wildcard not working,excel filter function contains partial text,
filter with partial match google sheets,excel filter function multiple criteria wildcard,filter function with wildcard google sheets,excel filter function with table,
filter function with wildcard excel,excel filter wildcard not working,filter with partial match google sheets,excel filter function with table,excel filter function contains partial text,