Please, I desperately need an Excel formula to automatically create a Class Schedule, regarding subject priorities (e.g. everyday German. Maths, Italian, and English have to be from I to IV classes in the morning).
Here you will find the document which I created manually and took me more than 5 hours:
Where to start?
How to make a formula to automatically fill in the cells of the class schedule without overlapping the subject and taking care of the priority of subjects?
Thank you,
Davor
Here you will find the document which I created manually and took me more than 5 hours:
Excel_Class_Schedule_Example.xlsx
docs.google.com
Where to start?
How to make a formula to automatically fill in the cells of the class schedule without overlapping the subject and taking care of the priority of subjects?
Thank you,
Davor