List.Mode
List.Mode(list as list, optional equationCriteria as any) as any
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.
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
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