MODE

MODE(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 is only available for backwards compatibility and should not be used.
* MODE.SNGL was added in Excel 2010 to replace this function.
* 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 MODE.MULT function to
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

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