Forum Discussion
Filter with Multiple Criteria
Try this formula change.
=FILTER(Database!A2:BH366,
(IF('Pull Data'!O2<>"", Database!H2:H366='Pull Data'!O2, TRUE))*
(IF('Pull Data'!P2<>"", Database!U2:U366='Pull Data'!P2, TRUE))*
(IF('Pull Data'!Q2<>"", Database!V2:V366='Pull Data'!Q2, TRUE))*
(IF('Pull Data'!R2<>"", Database!X2:X366='Pull Data'!R2, TRUE))*
(IF('Pull Data'!S2<>"", Database!Z2:Z366='Pull Data'!S2, TRUE))*
(IF('Pull Data'!T2<>"", Database!AA2:AA366='Pull Data'!T2, TRUE))*
(IF('Pull Data'!U2<>"", Database!AB2:AB366='Pull Data'!U2, TRUE))*
(IF('Pull Data'!V2<>"", Database!AK2:AK366='Pull Data'!V2, TRUE))*
(IF('Pull Data'!W2<>"", Database!R2:R366='Pull Data'!W2, TRUE)),
"none")
. I don't have a Mac myself to try it out, but it should work in Mac too...although I'm not so sure. 🙂
OMG, I cannot thank you enough! It worked! You really saved me. THANK YOU!!
- NikolinoDEJun 28, 2023Platinum Contributoryw