[PDF]Small Function In Excel

Imparting knowledge

Gyan Sangrah

Small function in excel

In this article, we will discuss small function in excel.

Purpose

The purpose of the function is to find the nth small number from the list.

Syntax

Small (List,n)



Example


,, 3"V ----



H

1

J

K

L

M



















4

5

6

7

8













SMALL(F3:J3,1)

Returns

r 4






SMALL{F3:J3,2)

Returns

r 5






SMALL{F3:J3,3)

Returns

r 6





























I-1


In the above example, small function is returning 1 st , 2 nd and 3 rd smallest number.