Name

SMALL

Synopsis

Use SMALL to find a specific value within an array based upon its size. For example, you can locate the third smallest number in the list.

To Calculate

=SMALL(Array, K)

Both arguments are required for this function.

Array

Indicates a range of numeric values.

K

Indicates a positive numeric value that indicates the position from largest to smallest that you want to find. To find the largest value in the array you specify a 1 for the K argument. If the value specified for the K argument is a decimal, it is rounded to the closest integer.

Example

Figure 15-42 illustrates how you can use SMALL to find the smallest and the next smallest values in a list of numbers. In order to find the smallest number, a value of 1 was specified for the K argument. To find the second smallest number, a value of 2 was specified for K.

Use SMALL to find a number based upon how much smaller it is than the other values

Figure 15-42. Use SMALL to find a number based upon how much smaller it is than the other values

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial