Hoping some formula-whiz might be able to lend a hand here. I am trying to write a formula that will accomplish the following: Given a set of X values, each of which belongs to one of Y classes, I want to generate all possible combinations of values, consisting of a single value for each class, wit…

Okay. I did it. The formula: Items.Group.Unique().Sort().WithName(Groups, Groups.FormulaMap(CurrentValue.WithName(CurrentGroup, Items.Filter(CurrentValue.Group = CurrentGroup).WithName(GroupItems, List( CurrentGroup, GroupItems, GroupItems.Count() ) ) )) ).WithName(Gr…

Formula for unique combinations

Connor_McCormick1 October 7, 2021, 8:16pm 3

Maybe this will help? Paul and I played with something that sounds somewhat similar:

1 Like

Topic		Replies	Views
All possibilities mixer?	8	1944	January 2, 2020
Coda Formula Challenge: All Combinations	8	2909	July 6, 2021
Combining rows from various tables into unique strings	6	648	February 23, 2021
Add row for every unique combination based on multiple columns	7	549	April 16, 2024
Dedupe an array of arrays based on a common key/object with formulamap()	15	2590	May 16, 2020

Formula for unique combinations

Related topics