Forum Discussion

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
Jul 08, 2021
joeyc380

Try it like this...

=FILTER(F10:I21,ISNUMBER(MATCH(F10:F21,F26:F28,0)))

Subodh_Tiwari_sktneer

Silver Contributor

Jul 08, 2021

joeyc380

Try it like this...

=FILTER(F10:I21,ISNUMBER(MATCH(F10:F21,F26:F28,0)))

PooriaForootan

Copper Contributor

Jul 20, 2023

Subodh_Tiwari_sktneer Holy ... your solution is amazing. I've been doing all types of crazy stuff to do what you just did so simply. You really saved me. Thanks.