How to create all possible pair combinations without duplicates

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.