Hello,
I want to randomize a list of names into two columns. I'm a teacher and I'm assigning lab partners that are different every lab. I'm hoping to automate this since what I'm doing now is cutting and pasting. I've tried adding a number to the front of each student, but get stuck after that.
This is what I'd like to do: (periods are just to make spacing, I'd like them to be in separate cells.)
Names:
Darth Vader
Luke Skywalker
Han Solo
Princess Leia
Chewbacca
Obi Wan Kenobi
Partners:
Lab 1
Darth Vader...........Luke Skywalker
Han Solo...............Princess Leia
Chewbacca............Obi Wan Kenobi
Lab 2
Darth Vader...........Princess Leia
Han Solo...............Chewbacca
Obi Wan Kenobi......Luke Skywalker
and so on.
Is this possible?
Thanks,
Paul
Bookmarks