Comment on page
List.Modes
Returns a list of the most frequent values in the list.
function (list
as list, optionalequationCriteria
as nullable any) as list
Returns the item that appears most frequently in the list,
list
. If the list is empty an exception is thrown. If multiple items appear with the same maximum frequency, the last one is chosen. An optional comparisonCriteria
value, equationCriteria
, can be specified to control equality testing.List.Averages
Find the items that appears most frequently in the list
{"A", 1, 2, 3, 3, 4, 5, 5}
.List.Modes({"A", 1, 2, 3, 3, 4, 5, 5})
{3, 5}
Last modified 5yr ago