An array formula, or set of them, could do this, for sure. But so could Data > AutoFilter >Custom.

...and I believe so could ADVANCED FILTER