Excel function to dynamically filter data?

Hi,

I am trying to perform a function in Excel that would be the equivalent to Google Sheets =filter() function. In the example I am providing, I want the rows of data that contain the phrase "Team 1" under the "Fantasy" column to be automatically copied into my "Team" worksheet. So as I type more "Team 1"s into more rows, those rows will be continuously added to the other sheet. It works perfectly in Google Sheets, but I can't find an Excel function or downloadable add-on that would do the job.

Thanks

Yahoo Question Draft.png

https://stackoverflow.com/questions/...lumn-for-total

Unfortunately I don't think they are available in V 2019, but in Office 365 you can now use the dynamic array formulas, of which =FILTER is one of them and you can do exactly this.