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.