I am setting up a workout schedule. I have multiple rows with workout times, who is instructing the class, and who the class is suitable for. The suitable is a range, based on the following (anyone with martial arts experience will recognize this as belt degrees):
- 10. cup
- 9. cup
- ...
- 1. cup
- 1. dan
- 2. dan
- ...
- 9. dan
My spreadsheet has the following columns:
- Day
- Time
- Lasts
- Where
- Instructor
- Minimum belt
- Maximum belt
- Curriculum
Each class is suitable for someone within a range of the minimum and maximum belt. Now, I am trying to let the students easily filter out classes by simply selecting their degree from a dropdown at the top of the spreadsheet, and have only rows that are for them display.
Each instructor should also be able to easily filter out only the classes they teach, but I already know how to do that.
How would I do this?