aeonrevolution
2[H]4U
- Joined
- Aug 30, 2004
- Messages
- 2,577
I've been racking my brain trying to figure out how to go about creating a spreadsheet to perform something for me and can't figure out the right angle to approach it from.
So. Here is what I'm trying to do. Numbers are arbitrary to explain.
I have 100 employees listed in seniority order. I have an equal number of jobs for them to pick from.
Each employee picks 5 jobs they wish to do for the next week in order of what they desire.
The highest seniority employee will receive his first choice. The second employee will receive his first choice unless the employee above him picked the same job. If both picked the same job as their first pick then the second employee would receive his second pick.
And so on and so on down the line.
Currently, we do this process by eyeballing it and lots of pencils crossing things off. It usually ends up in numerous errors and having to be second checked.
There must be a way to create a spreadsheet where all you have to do is punch in the employee's picks and then the worksheet will filter it all and spit out which job they will receive.
So. Here is what I'm trying to do. Numbers are arbitrary to explain.
I have 100 employees listed in seniority order. I have an equal number of jobs for them to pick from.
Each employee picks 5 jobs they wish to do for the next week in order of what they desire.
The highest seniority employee will receive his first choice. The second employee will receive his first choice unless the employee above him picked the same job. If both picked the same job as their first pick then the second employee would receive his second pick.
And so on and so on down the line.
Currently, we do this process by eyeballing it and lots of pencils crossing things off. It usually ends up in numerous errors and having to be second checked.
There must be a way to create a spreadsheet where all you have to do is punch in the employee's picks and then the worksheet will filter it all and spit out which job they will receive.