Forum Discussion
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 ...
Had a real head scratcher - I have a situation where the same client could have one or multiple account numbers and vendor names in our database, and needed a way to filter out their real account history, and this was the final puzzle piece - Thank you! (Took me a bit to figure out why it wasn't working, until I realized I had to switch the lookup value and lookup array around... I still don't fully know how it works, but it does!)
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.
- #2023 and still awesome answer. Thanks, exactly what i was looking for !
You're welcome asharif1377! Glad you found it helpful.
You're welcome joeyc380! Glad it worked as desired.
