Dependent Lists

Source Data under "Nerves_Data" tab:

Want to create a dependent list under "Day of Week Analysis" to see what sport and what corresponding days have the most impact (lift) 5 weeks up to game day, and 5 weeks after.

Need:

1) Formula to create a list (Day of Week) dependent on first list (Game Type)... see "Day of Week Analysis.. " Would want to have unique data from Nerve_Data!$A$2:$A$25 selected, no duplicates within the list.

2) Use both lists as a filter to return the 5 weeks up to game day and 5 weeks after data to display whenever data from each list are selected.


Thoughts?