Filter the table by formulas

[madocar]

Hello

I'm just wondering if it is possible to filter my table according 1 team by formula. I made an example of NHL team. I would like to get a list of all (home/away) games of Anaheim Ducks. I can do this by formula but with useless blank rows (blue background). I would like to create a formula to do the same without blank rows (green background).
Excel file in attachment.
Thanks for any help

 

[John Jairo V]

Hi @madocar.

Please check this file. Coment! Blessings!

 

[Smallman]

Hi madocar

Here is the same sort of example using a slightly different formula.

Take care

Smallman

 

[madocar]

Thanks a lot guys, you helped me a lot!