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
BulletedList + FormulaMap + Unique HELP	4	452	May 20, 2022
Dedupe an array of arrays based on a common key/object with formulamap()	15	2373	May 16, 2020
Add function to remove duplicates to formular	6	212	January 16, 2024
How many times each item repeats in a list	7	584	August 25, 2021
Looking for insights to suppress some redundancy in a "long" formula community-champions	6	843	October 20, 2021

Formula for unique combinations

Related Topics