Find the maximum, minimum value (MAX, MIN function) To find the maximum (max.), minimum (min.) value from a specific data in Excel, we use the following function. =MAX(number 1,[number 2],…) [number 1] = Select cell range or the first number in finding the max. value. [number 2] = Select cell range or the second number in・・・