MODE.MULT 
MODE.MULT(number1 [,number2] [..]) 
Returns the array of all the numbers that appears the most often in a set. 
number1  The first number you want to include. 
number2  (Optional) The second number you want to include. 
REMARKS 
* This function can return multiple values. * If not entered as an array formula this function is the same as MODE.SNGL * If there are no duplicates, then #N/A is returned. * For horizontal arrays, use TRANSPOSE(MODE.MULT()) * This will return more than one result if there are multiple modes. * Any test, logical values or empty cells are ignored. * You can have a maximum of 254 numbers. * You can use the MODE.SNGL function to return the value that occurs most frequently in a list or array of numbers. * This function was added in Excel 2010 * 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). Both the modes are returned. 4  What number appears most often in the set (2,2,1,1). Both the modes are returned. 5  What number appears most often in the set (3,1,2,2,1). Both the modes are returned. 6  What number appears most often in the set (3,2,1,1,2). Both the modes are returned. 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