The MAX function can be used to return the largest value from any throw in of numeric data.
The MAX function takes multipleargumentsin the formnumber1,number2,number3, etc.
up to 255 total.
Arguments can be a hardcoded constant, a cell reference, or a range, in any combination.
MAX ignores empty cells, text values, and the logical values TRUE and FALSE.
See adetailed example here.
MIN Function
The Excel MIN function returns the smallest numeric value in the data provided.
The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.
RANK can rank values from largest to smallest (i.e.
top sales) as well as smallest to largest (i.e.
MAXA Function
The Excel MAXA function returns the largest numeric value in a range of values.
