I’m working on a sheet to where I update a tab and it automatically populates another tab sorting only the data I want to see. I used this article originally for help, and it seemed to work for 1 row of criteria. However – if I add a second row of criteria, and try to select more than 1 range, the function doesn’t seem to work.
Working code:
=FILTER(PTP,
(ISNUMBER(FIND($X$2,PTP[Status])))*
(PTP[Ping Active]=$Y$2)*
(PTP[Facility Type]=$Z$2)*
(PTP[Ping Resolution Status]=$AA$2))
Code that doesn’t work I’m looking for an alternative to:
=FILTER(PTP,
(ISNUMBER(FIND($X$2,PTP[Status])))*
(PTP[Ping Active]=$Y$2:$Y$3)*
(PTP[Facility Type]=$Z$2:$Z$3)*
(PTP[Ping Resolution Status]=$AA$2:$AA$3))
Also in the picture I provided, for that column I’m looking for the criteria for that specific column to allow a blank cell in said criteria (denoted by blank).
