I'm trying to figure out how to use the advanced filter to extract data from a master list to another shorter list.
This is a master list of results of basketball games. A team can appear in either of two columns (column B and D in my sheet) as a home or visiting team.
I would like to be able to have Excel scan through columns B and D to find a specific team and return the following columns for all instances of that team onto a separate sheet. I would like for this to automatically update should the master list get longer. It appears that the Advanced Filter just copies the values once and will not update later.
Column A - date
Column B - visiting team
Column C - visiting team score
Column D - home team
Column E - home team score
Column F - Overtime? (OT, 2OT)
Column G - Neutral Location (if neutral)
What is the easiest way to accomplish this?
Bookmarks