Hi -
First time poster here, just joined.
I need to create an excel sheet that allows me to take 6 names and see all the permutations for 2 available slots.
ex)
list 1 (names)
Mary
Jon
Jim
Bob
Bruce
Carolyn
list 2 (seats)
1st Seat
2nd Seat
the key is I need all permutation, not combinations. So Mary and Jon could be 1st and 2nd seat, but another permutation is Jon and Mary in 1st and 2nd seat.
I am hoping whoever helps - it can be something I can use and change the variables in the two lists as needed over time.
hoping for a solution!!
Billy
Bookmarks