Hi all,
I am trying to make an advanced semi auto staffing sheet/depth chart for work. Say I have 30 positions to staff. I want to be able to list those positions and 3 to 5 people who are capable of each. When I select them in a position I want their name to be removed from other possible positions. For example I have Bob, John and Jane. All three can do job A but only Bob and Jane can do job b. I want to be able to have a staffing sheet where if I enter in Bob for job A then the list for all other jobs will no longer show him. I'm looking for a function or set of functions to be able to do this. Here is a crude example of what the raw data would look like and where I would be entering in a name.
| Position | 1 | 2 | 3 | 4 | 5 | | Position | |
| Drawer Front Cell | Alex | Charles | | | | | Drawer Front Cell | |
| Tally 3 | Matt | Zack | Sam | | | | Tally 3 | |
| Tally 2 | Sam | Brice | Matt | Zack | Todd | | Tally 2 | |
| Tally 1 | Matt | Todd | Sam | Zack | | | Tally 1 | |
| CDTally | | | | | | | CDTally | |
| Progressive | Charles | Nick | | | | | Progressive | |
| CA Supergluer | | | | | | | CA Supergluer | |
| Door Sander | Kelyenne | Tyler | | | | | Door Sander | |
| Carleson Operator | Caleb | Tyler | Jeremy | | | | Carleson Operator | |
| Carleson Builder | | | | | | | Carlson Builder | |
| Carleson Gluer | Austin | C.B. | | | | | Carlson Gluer | |
| Shimmer | Austin | Zack | C.B. | | | | Shimmer | |
| Panel Sander | Kevin | Michael | | | | | Panel Sander | |
| Panel Prep | Michael | Kevin | | | | | Panel Prep | |
| Martin Shapers | Byron | Chuck | Jeremy | | | | Martin Shapers | |
| Hendriks 1 | George | Tyler | Chuck | Jeremy | | | Hendriks 1 | |
| Hendriks 2 | Tyler | Chuck | Jeremy | | | | Hendriks 2 | |
| Warehouse | Matt | | | | | | Warehouse | |
| 5 Head Molder | Brad | Jeremy | | | | | 5 Head Molder | |
| 6 Head Molder | | | | | | | 6 Head Molder | |
| Lineal Puller | Shawn | | | | | | Lineal Puller | |
| S90 Operator | Nick | Shawn | Chuck | | | | S90 Operator | |
| S90 Offload | C.B. | Curtis | George | | | | S90 Offload | |
| Coper | C.B. | Curtis | Kathy | George | Nick | | Coper | |
| S90 Sequencer | John | Jeremy | Zack | | | | S90 Sequencer | |
| DMR JLT Clamp | Matt | Jeremy | Todd | Brad | | | DMR JLT Clamp | |
| Balastrini | Brad | C.B. | Tyler | | | | Balastrini | |
| Miter Build | Brad | C.B. | Tyler | | | | Miter Build | |
| Miter Prep | Brad | C.B. | Tyler | | | | Miter Prep | |
