Sep 01 2022 04:22 AM
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 |