Excel: data validation: filtering a dynamic list

hi I am hs coach building a workout planner in excel 2010, where I have an Athletes sheet and a workout sheet. On the workout sheet I am using dynamic list to select an athlete name and pull other data in via index and match. Currently all athletes show up in the list. I want to only have "active" athletes In that list. I do have an Active column on the athletes sheet. Currently the list is set as: =OFFSET(Athletes!$B$1,1,0,COUNTA(Athletes!$B:$B)-1,1) how can I filter out only the active athlete. Active column is D thanks in advance scott

This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of October 11, 2014.

For more resources for Microsoft Excel