MODE.SNGL(number1 [,number2] [..])

Returns the value that occurs most frequently in a list or array of numbers.

number1The first number.
number2(Optional) The second number.

* This function was added in Excel 2010 to replace the MODE function.
* This function has a different algorithm because the one used in the MODE function was inaccurate.
* The arguments have to be numbers.
* The arguments can be range names, arrays, or references but they must contain numbers.
* If an argument is an array or reference, any empty cells, text, logical values, or empty cells are ignored.
* Any arguments with the value zero are included.
* If the data set contains no duplicate data points, then #N/A is returned.
* You can have a maximum of 255 arguments.
* You can use the FREQUENCY function to return the number of times a particular value occurs.
* For the Microsoft documentation refer to

1=MODE.SNGL({5.6,4,4,3,2,4}) = 4
2=MODE.SNGL({1,1,1,1,3,3,3,3,4,4,4,4}) = 1
3=MODE.SNGL(2,4,6,8) = #N/A

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top