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
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