Forum Discussion
Solved
Auto populate available shifts according to rank
Hello. Our department has at least 20-40 overtime shifts a month. We have 13 full time officers ranked by seniority (chief to regular patrolman). I am trying to create an excel sheet that (once ev...
Please see how far my enclosed solution corresponds to your ideas.
You can then donate the money to a charitable institution.
Hiofficerdon,
I have made a second version without modern functions like FILTER() and XMATCH(). Please try the two new spreadsheets (old scool) and see if it works for you.
Works flawlessly!!! Thank you so much. Got next months OT schedule done in record time! Your time is greatly appreciated!!