Allocation of a a fixed staff list, without duplication

[mpgates]

Hi all,

Trying to find the best way around an issue I have come accross.

I'm running events, and have a list of staff who are all open to work 3 events, and they all have unique ID's.

I have 3 columns, event 1,2,3, and I need to allocate the staff out to each event. I need to do this without duplication, but also I need to somehow show in the availability table that they have been allocated, i.e at the end I can see who's still free?

This is the simplified version of what I need. I know about conditional formatting, so can highlight duplicates if needed but was hoping for a way that they no longer are available to pick, as opposed to just being red.

I'm building a staff rostering tool from scratch so any help appreciated.

Cheers.

[newdoverman]

You don't say how many people are involved or how many are in each event. I have started out with 3 people for each event but that can be changed. I have also made allowances for 16 people but that can also be changed.