Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Syntax
List.Mode(list as list, optional equationCriteria as any) as any
About
Returns the item that appears most frequently in 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 comparison criteria value, equationCriteria, can be specified to control equality testing.
Example 1
Find the item that appears most frequently in the list {"A", 1, 2, 3, 3, 4, 5}.
Usage
List.Mode({"A", 1, 2, 3, 3, 4, 5})
Output
3
Example 2
Find the item that appears most frequently in the list {"A", 1, 2, 3, 3, 4, 5, 5}.
Usage
List.Mode({"A", 1, 2, 3, 3, 4, 5, 5})
Output
5