"Within Excel$$s advanced filter, in order to filter a list that must satisfy two criteria simultaneously, the user must set up the condition in the criteria range by placing both criteria on the same row. hat$(E)"$

And

Or

Parallel$$

Join