MODE.SNGL

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

Returns the first number that appears the most often in a set.

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

REMARKS
* This function was added in Excel 2010 to replace the MODE function.
* Arguments that are references to cells containing zeros are included
* Arguments that are references to cells containing dates are included
* Arguments that are references to cells containing logical values are excluded
* Arguments that are references to cells containing text are included
* Arguments that are references to cells containing error values will be returned
* Arguments that are references to empty cells are excluded.
* If there are no duplicate values, then #N/A is returned.
* If there are multiple values that occur the same number of times, the first value is returned.
* If there are any cell references to empty cells, then #VALUE! is returned.
* 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 AVERAGE function to return the arithmetic mean of the values in a list, table or cell range.
* You can use the FREQUENCY function to return the number of times a particular value occurs.
* You can use the MEDIAN function to return the number in the middle of a set of numbers.
* You can use the MODE.MULT function to return the array of most frequent or repetitive values.
* For the Microsoft documentation refer to support.microsoft.com

 AB
1=MODE.SNGL(1,2,3) = #N/A0
2=MODE.SNGL(1,2,3,1) = 11
3=MODE.SNGL(1,1,2,2) = 110
4=MODE.SNGL(2,2,1,1) = 2 
5=MODE.SNGL(3,1,2,2,1) = 10
6=MODE.SNGL(3,2,1,1,2) = 2text
7=MODE.SNGL(B1,B2, B3,B4) = #VALUE!TRUE
8=MODE.SNGL(B1,B2, B3,B5) = 0FALSE
9=MODE.SNGL(B1,B2, B3,B6) = #N/A=DATE(2024,1,1) = 01 Jan 2024
10=MODE.SNGL(B1,B2, B3,B7) = #N/A=10/0 = #DIV/0!
11=MODE.SNGL(B1,B2, B3,B8) = #N/A 
12=MODE.SNGL(B1,B2, B3,B9) = #N/A 
13=MODE.SNGL(named_range) = #N/A 
14=MODE.SNGL(B1,B2, B3,B10) = #DIV/0! 
15=MODE.SNGL(2,"2") = #N/A 
16=MODE.SNGL(1,TRUE) = #N/A 
17=MODE.SNGL(0,FALSE) = #N/A 
18=MODE.SNGL(0, "some text") = #N/A 
19=MODE.SNGL({0,"some text"}) = #N/A 
20=MODE.SNGL({1,TRUE}) = #N/A 

1 - What number appears most often in the set (1,2,3). No mode.
2 - What number appears most often in the set (1,2,3,1). One mode.
3 - What number appears most often in the set (1,1,2,2). Two modes.
4 - What number appears most often in the set (2,2,1,1). Two modes.
5 - What number appears most often in the set (3,1,2,2,1). Two modes.
6 - What number appears most often in the set (3,2,1,1,2). Two modes.
7 - What number appears most often in the range "B1", "B2", "B3" and "B4". B4 is an empty cell so #VALUE! is returned.
8 - What number appears most often in the range "B1", "B2", "B3" and "B5". B5 is zero so this gets included. One mode.
9 - What number appears most often in the range "B1", "B2", "B3" and "B6". B6 is text so this gets excluded. No mode.
10 - What number appears most often in the range "B1", "B2", "B3" and "B7". B7 is a logical value to this is excluded. No mode.
11 - What number appears most often in the range "B1", "B2", "B3" and "B8". B8 is a logical value so this is excluded. No mode.
12 - What number appears most often in the range "B1", "B2", "B3" and "B9". B9 is a date so this gets included as a date serial number. No mode.
13 - What number appears most often in the named range that refers to the range "B1:B3". No mode.
14 - What number appears most often in the range "B1", "B2", "B3" and "B10". B10 contains an error so that gets returned.
15 - What number appears most often in the set (2,"2"). Text values that are actually numbers are excluded. No mode.
16 - What number appears most often in the set (1,TRUE). Logical values passed as arguments are excluded. No mode.
17 - What number appears most often in the set (0,FALSE). Logical values passed as arguments are excluded. No mode.
18 - What number appears most often in the set (0,"some text"). Text values passed as arguments are excluded. No mode.
19 - What number appears most often in the array {0,"some text}. Text values inside arrays are excluded. No mode.
20 - What number appears most often in the array {1,TRUE}. Logical values inside arrays are excluded. No mode.

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