Excel MAX and MIN
https://www.powerupbusiness.net/training
The MAX and MIN functions pinpoint the highest and lowest values by examining every entry in the dataset, without categorizing.
MAX function
Description
Returns the largest value in a set of values.
Syntax
MAX(number1, [number2], ...)
MIN function
Description
Returns the smallest number in a set of values.
Syntax
MIN(number1, [number2], ...)