Description Computes the most frequent value in a list of numbers (the number that appears most often in the list).
Syntax MODE (number_list)
| Argument | Description |
|---|---|
| number_list | A list of between 1 and 30 arguments consisting of numbers, cell references, range references, and/or array constants.All numeric values, including 0, are used. Text, logical values, and empty cells are ignored. |
Remarks If no number is repeated in number_list, the error value #N/A is returned.
Example This function returns 3:
