Good Evening!
I have a classroom that has a max of 12 students in it. Every 5 weeks the class size fluctuates, so it's not always a static 12 students. I am trying to figure out how to create a spreadsheet in Excel that can organize the partners so that there are no repeats until all the pairing options have been exhausted.
I found a great video online, only to find out that it MRAND doesn't work with my Office version (2016). (It's here if you would like to see what I have found thus far: youtube.com/watch?v=rYrGF8ib7WY)
I've been trying to come up with a way to do this in Excel for well over a year and can't figure it out.
Thank you so much for your help!
Brandi
Bookmarks