Help

How to create all possible pair combinations without duplicates

Topic Labels: Formulas
596 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Sarah_Inman
4 - Data Explorer
4 - Data Explorer

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.

0 Replies 0