Minimum And Maximum Values.

To get the minimum value from a set of numbers, use the MIN function


As you can see, we enter the MIN function in cell H3 and then copy it down all the way. The formula can be seen in the formula bar: =MIN(C3:E3). This will display the mimimum values for each person for Jan, Feb and March. 

The same can be used to get the Maximum value: =MAX(C3:E3). This will display all the Maximum values.