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)))
#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ
Watch video How to do partial match with FILTER function - Excel Tips and Tricks online without registration, duration hours minute second in high quality. This video was added by user Rabi Gurung 06 September 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 157 once and liked it 7 people.