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

List.Modes

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Returns all items that appear with the same maximum frequency.

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

Arguments

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

Remarks

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

Example

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