# SMALL & LARGE functions

The SMALL function returns the k-th smallest number from an array of numbers.

The SMALL function syntax is as follows:

= SMALL ( array; k )

Array can be any row, column, or a combination of both.

k is an integer number representing the position of a number in the array if data in that array would be sorted from the smallest.

Consider the following example:

If k is 1, the smallest number will be returned.

If k is the same number as the total count of numbers in an array, the largest number will be returned.

If k is zero, smaller than zero, or larger than the total count of numbers in an array, an error will be returned.

The SMALL function is useful if we want to return the k-th (2nd, 3rd) smallest number in an array.

If the smallest numbers are repeating, the 2nd, 3rd, etc. smallest numbers will be the same as the first.

The LARGE function returns the k-th largest number from an array of numbers.

The LARGE function syntax is as follows:

= LARGE ( array; k )

An array can be any row, column, or combination of both.

K is an integer number representing the position of a number in the array if data in that array would be sorted from the smallest.

Consider the following example:

If k is 1, the largest number will be returned.

If k is the same number as the total count of numbers in an array, the smallest number will be returned.

If k is zero, smaller than zero, or larger than the total count of numbers in an array, an error will be returned.

The LARGE function is useful if we want to return the k-th (2nd, 3rd) largest number in an array.

If the largest numbers are repeating, 2nd, 3rd, etc. largest numbers will be the same as the first.

Dig deeper:

Numbers in Excel

RANK functions