MAXA 
MAXA(value1 [,value2] [..]) 
Returns the largest value in a list or array of numbers (including logical values and text). 
value1  The first value. 
value2  (Optional) The second value. 
REMARKS 
* This function is identical to the MAX function except that logical values and text are included. * This function includes hidden cells. * Arguments that are numbers are included. * Arguments that are numbers passed as text ("3") are included. (Row 15) * Arguments that are zero are included. * Arguments that are dates are included and the date serial number will be used. * Arguments that are cell references to cells containing logical values are included. * Arguments that are arrays containing logical values are included. * Arguments that are just logical values are included. * Arguments that evaluate to True are included and 1 is used. * Arguments that evaluate to False are included and 0 is used. * Arguments that are cell references to cells containing text are included. * Arguments that are arrays containing text are included. * Arguments that are just text will generate a #VALUE! error. * If any cell references are empty, then these are excluded. * If any cell references contain an error, then that error is returned. * You can have a maximum of 255 arguments. * You can use the MAXAVISIBLE  User Defined Function to exclude hidden cells. * This is similar to the AVERAGEA, COUNTA and MINA functions. * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com 

1  What is the largest of 2 and 4. 2  What is the largest of 5, 10 and 15. 3  What is the largest of 5, 10, 15 and 0. 4  What is the largest of 2, 3, 4, 5 and 6. 5  What is the largest of the values in the array (2, 3, 4, 5, 6). 6  What is the largest of the values in range "B1:B3". 7  What is the largest of the values in range "B1", "B2" and "B3". 8  What is the largest of the values in range "B1", "B2", "B3" and "B4". B4 is empty. 9  What is the largest of the values in range "B1", "B2", "B3" and "B5". 10  What is the largest of the values in range "B1", "B2", "B3" and "B6". 11  What is the largest of the values in range "B1", "B2", "B3" and "B7". 12  What is the largest of the values in range "B1", "B2", "B3" and "B8". B8 is a date so this gets included as a date serial number. 13  What is the largest of the values in the named range that refers to the range "B1:B3". 14  What is the largest of the values in range "B5", "B6" and "B9". B9 contains an error so that gets returned. 15  What is the largest of 2 and 3. Text values that are actually numbers are included. 16  What is the largest of 2 and "some text". Text values passed as arguments are excluded. 17  What is the largest of the values in the array (2, "some text"). Text values inside arrays are excluded. 18  What is the largest of 2 and TRUE. Logical values passed as arguments are included. 19  What is the largest of 2 and FALSE. Logical values passed as arguments are excluded. 20  What is the largest of the values in the array (2, TRUE). Logical values inside arrays are excluded. 
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top