Creating Rotation List

[Tootone]

I have a rotation list I have been asked to maintain. Using ID numbers, I want to rotate the id's for the four specific job functions. Example

Week Function 1 Function 2 Function 3 Function 4
04/03/11 ID 1 ID 2 ID 3 ID 4
04/10/11 3 4 2 1
04/17/11 2 3 1 4

Any Ideas Please!

 

[Akashwani]

Hi,

I'm not sure what you want to do that you already haven't done with your sample.

Excel Workbook
	A	B	C	D	E	F
8	Week	*	Function1	Function2	Function3	Function4
9	03/04/2011	*	ID1	ID2	ID3	ID4
10	10/04/2011	*	ID2	ID3	ID4	ID1
11	17/04/2011	*	ID3	ID4	ID1	ID2
12	24/04/2011	*	ID4	ID1	ID2	ID3
13	01/05/2011	*	ID1	ID2	ID3	ID4
14	08/05/2011	*	ID2	ID3	ID4	ID1
15	15/05/2011	*	ID3	ID4	ID1	ID2
16	22/05/2011	*	ID4	ID1	ID2	ID3
17	29/05/2011	*	ID1	ID2	ID3	ID4
18	05/06/2011	*	ID2	ID3	ID4	ID1
19	12/06/2011	*	ID3	ID4	ID1	ID2
20	19/06/2011	*	ID4	ID1	ID2	ID3
Sheet7

Ak

 

[Tootone]

I'm looking for a formula or function that will randomly rotate the employee ID's for different job functions each week, rather than manually assigning.

thanks

 

[XL&ME]

Have you tried using the randbetween function? Bottom number 1, and top number 4. Then drag down or across as needed.

 

[Tootone]

I'll try it out and let you know.

thanks

 

[Akashwani]

Hi,

Using RANDBETWEEN could and probably will give you duplicates.

Look here for a VBA solution, possibly the only solution without manually entering 4 rows of data and copying them.

http://www.mcgimpsey.com/excel/udfs/randint.html

Good luck

Ak

 

[Tootone]

Good afternoon,
RANDBETWEEN will not work because of possible duplicate ID assignments in a given week. I am looking more for a rotation list function. 10 individual id #'s to assign to 5 different job functions rotating each week. Still fishing.... Any ideas are greatly appreciated