Setting up a template for course registrations need help with limiting?

%3CLINGO-SUB%20id%3D%22lingo-sub-2815278%22%20slang%3D%22en-US%22%3ESetting%20up%20a%20template%20for%20course%20registrations%20need%20help%20with%20limiting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2815278%22%20slang%3D%22en-US%22%3E%3CP%3EAt%20least%20I%20think%20that%20is%20where%20I%20need%20help!%20Say%20there%20are%20seventy%20students%20to%20be%20split%20into%20two%20lecture%20groups%20(two%20days)%2C%20and%20then%20also%20need%20labs%20to%20go%20with%20those%20days%20from%20that%20course%2C%20with%20limited%20seating.%20Which%20formula%20or%20data%20validation%20way%20to%20set%20it%20up%20to%20count%20down%20the%20number%20of%20seats%20used%20up%3F%20What%20is%20the%20best%20and%20most%20streamlined%20way%20to%20do%20it%3F%20Because%20I%20not%20only%20have%20one%20class%20and%20set%20of%20labs%2C%20but%20also%20two%20other%20classes%2C%20contingent%20on%20these%20schedules%2C%20along%20with%20clinical%20experiences%20as%20well.%20I%20have%20a%20rather%20timeconsuming%20set%20up%20already%20in%20place%2C%20and%20each%20semester%20I%20learn%20more%20on%20how%20to%20simplify%20it%20all.%20But%20if%20I%20can%20learn%20the%20right%20way%20now%2C%20I%20can%20set%20it%20up%20for%20further%20use.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Excel%20I%20am%20using%20is%20currently%20is%20Excel%2016%20from%20my%20Office%20365.%20I%20am%20probably%20missing%20something%20massively%20simple%2C%20but%20am%20still%20learning!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2815278%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

At least I think that is where I need help! Say there are seventy students to be split into two lecture groups (two days), and then also need labs to go with those days from that course, with limited seating. Which formula or data validation way to set it up to count down the number of seats used up? What is the best and most streamlined way to do it? Because I not only have one class and set of labs, but also two other classes, contingent on these schedules, along with clinical experiences as well. I have a rather timeconsuming set up already in place, and each semester I learn more on how to simplify it all. But if I can learn the right way now, I can set it up for further use. 

The Excel I am using is currently is Excel 16 from my Office 365. I am probably missing something massively simple, but am still learning! 

0 Replies