Fresh Excel Tips

To determine the smallest value in a list, we can use the MIN function. However, the easiest way to find multiple small values of a range is by using the SMALL function. This function returns the nth smallest value in a set of data. Here is the syntax that is used for the SMALL Function:

SMALL(array, n)
array: An array or range of numerical data in which you want to find the nth smallest value.
n: The position from the smallest in the array or range of data to return.

To determine the three smallest values of a range:

1. In cells A1:A10 enter any values from 100 to 999.
2. Select cell C1 and type the following formula =SMALL($A$1:$A$10,1) to get the smallest value.
3. In cell C2 type the formula =SMALL($A$1:$A$10,2) to get the second smallest value.
4. In cell C3 type the formula =SMALL($A$1:$A$10,3) to get the third smallest value.

This tip is compatible with Excel 97, 2000, 2003 and 2007.

1. How to Use the LARGE function to find the highest values in Excel
2. Use the MIN function to detect the smallest value in a column
3. Use the MIN function to find the employee with the lowest sales
4. How to Use the QUARTILE function to calculate the quartiles
5. Using the SUM function to Sum a Range of Values in Excel