
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 16, 2022 09:05 AM
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
