The Mode function returns the most frequently occurring value in columns of numbers.
numbers references the column that contains the numbers on which the mode is calculated.
break_col is an optional parameter that references a break column.
Null values in the numbers column are ignored. Zeroes (0) are included. If the numbers column has no duplicate data values, the Mode function returns the value of the first cell in the numbers column. |
The following examples show the results of inserting the Mode function in two separate tables.
In this example, the Mode function is used on the numeric column. The results are shown in the Computed column.
Mode(Amount)