Function to get the mode.
However, this function has been deprecated, so use the MODE.SNGL function.
How it works
=MODE(number1 to 255)
| Name | Omission | Description |
|---|---|---|
| number1 to 255 | Required argument. | Specify a list of numbers to get the mode. |
Demonstrate
In this example, the mode values are 2 and 9, but only one mode value can be obtained.
In this case, the first (top-left) 9 is the result of the MODE function.
---