Varied Job Schedule, Excel

[brnedon bourne]

I've been working on an idea on how to create a job schedule from a list of names and a list of numbers (numbers are positions) I'd like it to generate 4 columns of predefined numbers so that each person has a unique number for each column. Ex.
1 2 3 4
Jim 21 22 11 10
Dave 10 11 21 22
Will 11 10 22 21
John 22 21 10 11

Does anyone know how I might be able to accomplish this?
I'm not to familiar with the int or rand function in excel and i think they might be needed.

[NeoPa]

You may want to rewrite this question Brendon. I didn't answer as I have only a vague idea of what you're trying to ask. It looks like everyone else was equally mystified.

[Doomtees]

Answer

You may want to rewrite this question Brendon. I didn't answer as I have only a vague idea of what you're trying to ask. It looks like everyone else was equally mystified.

This is what I was working on. It generates a production schedule automatically instead of it being handwritten, each number corresponds to a job position, we rotate positions to reduce the stress of repetitive actions.

[MMcCarthy]

As I understand your question you will have a list of numbers (e.g. 10,11,21 and 22) and you want to make sure than no two people have the same number in any column. So each column would be unique values. Am I correct?

If so can you guarantee that there will always be at least as many numbers as people or will you just stop assigning people when you run out of numbers. So if you only had 10 numbers you could only ever assign a maximum of 10 people.

[NeoPa]

That is not rewriting the question as far as I can see. It is posting an attachment. Without a fundamental question to base everything else around, there is no place to start.