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 
* 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 

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