Use the SMALL function to find the smallest values in Excel
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:
- In cells A1:A10 enter any values from 100 to 999.
- Select cell C1 and type the following formula =SMALL($A$1:$A$10,1) to get the smallest value.
- In cell C2 type the formula =SMALL($A$1:$A$10,2) to get the second smallest value.
- 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.
- Use the MIN function to detect the smallest value in a column
- Use the FLOOR function to round down values to the nearest 100
- How to use the COUNTIF function to count values in Excel
- How to Use the PRODUCT function to multiply values in Excel
- How to Use the PRODUCT function to multiply conditional values
