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}