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 

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