Skip to main content

List.Modes

Returns a list of the most frequent values in the list.

Syntax

List.Modes(
list as list,
optional equationCriteria as any
) as list

Remarks

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.

Examples

Example #1

Find the items that appears most frequently in the list <code>{"A", 1, 2, 3, 3, 4, 5, 5}</code>.

List.Modes({"A", 1, 2, 3, 3, 4, 5, 5})

Result:

{3, 5}

Category

List.Averages