# MODE.SNGL

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

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

 number1 The 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

 A B 1 =MODE.SNGL(1, 2, 3) = #N/A 0 2 =MODE.SNGL(1, 2, 3, 1) = 1 1 3 =MODE.SNGL(1, 1, 2, 2) = 1 10 4 =MODE.SNGL(2, 2, 1, 1) = 2 5 =MODE.SNGL(3, 1, 2, 2, 1) = 1 0 6 =MODE.SNGL(3, 2, 1, 1, 2) = 2 text 7 =MODE.SNGL(B1, B2, B3, B4) = #VALUE! TRUE 8 =MODE.SNGL(B1, B2, B3, B5) = 0 FALSE 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.