MODE.SNGL function
Summary
Returns the most common value in a data set
Syntax
MODE.SNGL(number1,[number2],...)
The MODE.SNGL function syntax has the following arguments:
• Number1 Required. The first argument for which you want to calculate the mode.
• Number2, ... Optional. Arguments 2 to 254 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 argument for which you want to calculate the mode.
• Number2, ... Optional. Arguments 2 to 254 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.SNGL(A2:A7)