Use the MIN function to detect the smallest value in a column - Basic Statistical Functions - Microsoft Excel Tutorials

Use the MIN function to detect the smallest value in a column using Microsoft Excel

To determine the smallest value in a single column, the MIN function is used. This function returns the smallest value in a set of values. The syntax is described in the previous tip.

To determine the smallest value in a column:

1. In column A, type any values down to cell A10.
2. Select cell B1 and type the following formula: =MIN(A:A).
3. Press <-Enter->.

Use the MIN function to detect the smallest value in a column

Note: To determine the smallest value in a row, such as the smallest value in the first row, use the formula =MIN(1:1). To get the smallest value of the first three rows, use the following function: =MIN(1:3).