Rotating List of Partners Automatically

Is there a way to set up a excel sheet to automatically setup people together per month?
We have to swap people every month for electricians and these are the beginning 3 months but since we cant just move people down 1 I was curious if theres a formula that may be able to help?Rotationv2.xlsx

Put this formula in D2:

=INDEX(B$2:B$6,MOD((ROWS($1:1)-1)+2,5)+1)

and copy down to D6. Then select the cells D2:D6, click copy, move cursor to F2, then CTRL-V, move cursor to H2, then CTRL-V, move cursor to J2, then press |Enter|.

The formula moves each person up 2 places (or you could consider it down 3 places which wraps after 5) from the previous month, but you can change the number of places by changing the 2 (shown in red) in the formula.

Hope this helps.

Pete

Hope this helps.

Pete

Awesome! Thanks so much, Just curious what happens if one of the months we add 2 new people? 1 blue 1 white wich part of the formula would I edit? "=INDEX(B$2:B$8,MOD((ROWS($1:1)-1)+2,7)+1)"??

You would change the formula to this:

=INDEX(B$2:B$7,MOD((ROWS($1:1)-1)+2,6)+1)

as you would now have 6 pairs of people (you had 5 pairs before).

Hope this helps.

Pete