List.Modes
List.Modes(list as list, optional equationCriteria as any) as list
Returns the items that appear most frequently in list
. If the list is empty an exception is thrown. If multiple items appear with the same maximum frequency, all of them are returned. An optional comparison criteria value, equationCriteria
, can be specified to control equality testing.
Find the items that appears most frequently in the list {"A", 1, 2, 3, 3, 4, 5, 5}
.
Usage
List.Modes({"A", 1, 2, 3, 3, 4, 5, 5})
Output
{3, 5}