I am trying to use excel to come up with a flow plan for my students. I have 5 color stations (yellow, pink, purple, green, and blue). I don't want them following each other. i.e. The ones that start on blue, will be sent to random color stations. Some yellow. Some pink. etc. In the end, they will need to have done all 5 stations. So, one students might go blue, yellow, pink, purple, green. Another might be blue, purple, green, pink, yellow. Another yellow, green, purple, pink, blue. Do you know any rand function that will help me determine the various routes?
Solved by I. J. in 18 mins