Table of contents
TOC
Collapse the table of content
Expand the table of content

List.Mode

Owen Duncan|Last Updated: 4/19/2018

About

Returns an item that appears most commonly in a list.

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

Arguments

ArgumentDescription
listThe List to check.
optional equationCriteriaControls the sort order. For more information about equality comparisons, see Parameter Values.

Remarks

  • If more than 1 item appears with the same maximum frequency, the last item in the first appearance order is chosen.

  • If the list is empty, an Expression.Error is thrown.

Example

List.Mode({"A", 1, 4, 5, 2, "B", 3, 5, 5, 4, 4}) equals 5  
© 2018 Microsoft