6. Find the minimum, the maximum and the range.

To find the minimum and maximum values in the dataset, you may:

Skjermbilde 2016-11-29 08.52.48a) sort the dataset (A1:A100) using the Sort Smallest to Largest functionality which you will find by clicking on the Sort & Filter icon, in the Editing section of the ribbon under the Home tab. Simply retrieve the lowest and highest (the first and last, respectively) value in the column.


Skjermbilde 2016-11-29 08.53.22b) use the functions =MIN(...) and =MAX(...) to get the minimum and maximum values of the dataset, respectively. In our example, type =MIN(A1:A100) and =MAX(A1:A100).


Skjermbilde 2016-11-29 08.54.50To calculate the range of the dataset, no predefined function can be found. You’ll have to calculate manually the difference between the maximum and the minimum of the dataset. In that case, simple type the formula =MAX(...)-MIN(...). In our example, this means =MAX(A1:A100)-MIN(A1:A100).


  Fant du det du lette etter? Did you find this helpful?
[Average: 0]