Hi! Anyone have any solutions on how to create a formula that would allow me to input a list of say 10 people and then create all possible pair combinations without creating duplicates?
Example:
Name 1
Name 2
Name 3
Name 4
Name 5
Then I would want to create 10 groupings where each name is paired with each other at least once without duplicating.
I’ve tried using autonumber, but can’t seem to figure out the formula to create this.
