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