List.Modes

Syntax

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

About

Returns the items that appear most frequently in list. If the list is empty an error is raised. 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.

Example

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}

Related content

Equation criteria