MODE function. Get mode.(Microsoft Excel)

Japanese version.

Function to get the mode.

However, this function has been deprecated, so use the MODE.SNGL function.

How it works

=MODE(number1 to 255)
NameOmissionDescription
number1 to 255Required 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.

---

Links

Microsoft Excel Functions Statistical