Minimum And Maximum Values.

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

=MIN(range)

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.

excelguy.co.za 

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

excelguy.co.za