MODE function
Summary
Returns the most common value in a data set
Syntax
MODE(number1,[number2],...)
The MODE function syntax has the following arguments:
• Number1 Required. The first number argument for which you want to calculate the mode.
• Number2,... Optional. Number arguments 2 to 255 for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas.
• Number1 Required. The first number argument for which you want to calculate the mode.
• Number2,... Optional. Number arguments 2 to 255 for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas.
Example
=MODE(A2:A7)