Microsoft Excel Functions & Formulas

Use the SMALL function to find the smallest

values in a list

To determine the smallest value in a list, we can use the MIN func-

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

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.

4

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