Jul 07 2021 08:02 PM
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
I'd like to use the =filter to return an dynamic array by using "criteria range", as if what the 'advanced filter' can do to filter multiple criteria of a particular column:
I know that =filter can do multiple criteria, by including each criteria in the formula one-by-one:
however, comparing to a single 'criteria range/ array', this method is far too troublesome especially when there is a long list of criteria for a particular column.
Did I make any mistakes in the =filter formula with a 'criteria range'?; or the =filter formula is just not capable to do that?
Thank you!
Jul 07 2021 08:17 PM
SolutionJul 07 2021 08:28 PM
Jul 07 2021 08:40 PM
You're welcome @joeyc380! Glad it worked as desired.
Jun 21 2022 02:00 AM
Jun 21 2022 03:14 AM
You're welcome @asharif1377! Glad you found it helpful.
Feb 28 2023 12:55 AM
Jul 20 2023 08:45 AM
@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.