Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to create all possible pair combinations without duplicates

Topic Labels: Formulas
228 0
Showing results for 
Search instead for 
Did you mean: 

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?

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