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).

Use the MIN function to find the employee with the lowest sales - Basic Statistical Functions - Microsoft Excel Tutorials

Use the MIN function to find the employee with the lowest sales using Microsoft Excel

In a company, employee sales are monitored. Columns B to E contain the sales for the first four months of the year. To determine which employee has the lowest monthly sales, use the MIN function. The function’s return value is the smallest value in a set.

MIN(number1, number2, ...)

number1, number2, ...: From 1 to 30 numbers for which you want to find the smallest value. It is possible to use a cell reference; however, the cells must contain numbers or values that can be converted to numbers.

To determine the lowest monthly sales:

1. In a worksheet, copy the range A1:E10 shown in Figure.
2. Select cells B12:E12 and type the following formula: =MIN(B2:B10).
3. Press <-Ctrl+Enter->.

Use the MIN function to find the employee with the lowest sales

Note: Later you will learn how to automatically shade the smallest value in each column.