Hi,

My boss asked me about our roster and doing it smarter.

He wants to know if we can have drop-downs in each of the roles to select from the staff for the day.
There's actually about 30 roles and people get swapped around each day. (And about 50 staff to choose from.)
I immediately thought of using a pivot.

The he asked, "How can you make it so that it excludes people already selected, so they don't mistakenly get assigned to 2 or more roles?"

e.g. John/counter1, Betty/counter2, Pete/greeter, Sue/appointments

I thought, a pivot with lots of if/then formulas, but maybe you have a better idea?

Your input would be most appreciated!!
Thank you.