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

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

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


* MODE.SNGL was added in Excel 2010 to replace this function.
* 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 30 arguments.
* For the Microsoft documentation refer to

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

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