Hi everyone,

I know there are a number of different requests out there that are somewhat similar to what I am about to ask, but I am struggling to find one that is exactly what I want.

I have a section of my team that gets rostered onto certain positions, but there are some that complain about continually working with the same person. What I want to do is have Excel generate a list of every possible "combination" of names for the roster.

Basically what I have is the five names listed across row 1, A1(Terry), B1(Marley), C1 (Mark), D1 (Francis) and E1 (Wayne).

Obviously the names can only appear once in each row as they can only work in one position at a time.

I hope I have made my request clear, but please feel free to ask more questions if you need. Any assistance or advice is greatly appreciated.