Forum Discussion
Formulas
Is there a formula I can use to compare tables on different sheets to track things like student jobs in the classroom. To keep track of how many times a student has a job to make sure every student h...
Thank you I uploaded my sheet for you. Riny_van_Eekelen
One more question I have... is there a way to get excel to take the names and randomly fill them into the jobs?
You have 11 jobs, 41 weeks to be performed by 22 students. Hence, every student has to perform each job about twice.
Have a look at the sheet StudentNames. If you start top-left in the first week. Hannah to Reagan will each take one of the 11 jobs. The next week it will be Jillian to Emma. Of course, that will not help you for the going year. But perhaps for the future.
- Thank you! You have been a big help 🙂
Its perfect thank you so much. I used to make spreadsheets all the time and have taken a few classes but haven't done many in the last couple years, I need to get refreshed on the formulas! Riny_van_Eekelen