Forum Discussion

joeyc380's avatar
joeyc380
Copper Contributor
Jul 08, 2021
Solved

Can Excel =filter function include a 'criteria range' for multiple criteria of one column?

Hello Everyone,   I am trying to use  =filter formula to filter multiple criteria for a single column as below, by using a "criteria range": However it is not working and return an #N/A ...
excel
office 365
Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Jul 08, 2021

joeyc380 

 

Try it like this...

 

=FILTER(F10:I21,ISNUMBER(MATCH(F10:F21,F26:F28,0)))
asharif1377's avatar
asharif1377
Copper Contributor
Jun 21, 2022
Subodh_Tiwari_sktneer

Your solution is excellent

It has shortened my formula about 99%

Thank you

Resources