SMALL ()
This
function examines a list of values and picks the value at a user specified
position in the list.
Best view in desktop mode.
A
|
B
|
C
|
D
|
E
|
F
|
|
1
|
Values
|
|||||
2
|
120
|
Lowest
Value
|
100
|
=SMALL(A2:A7,1)
|
||
3
|
800
|
2nd
Lowest Value
|
120
|
=SMALL(A2:A7,2)
|
||
4
|
100
|
3rd
Lowest Value
|
120
|
=SMALL(A2:A7,3)
|
||
5
|
120
|
4th
Lowest Value
|
250
|
=SMALL(A2:A7,4)
|
||
6
|
250
|
5th
Lowest Value
|
800
|
=SMALL(A2:A7,5)
|
||
7
|
1250
|
|||||
8
|
||||||
Syntax
=SMALL(ListOfNumbersToExamine,PositionToPickFrom)
Formatting
No special
formatting is needed.
Example
The following table was used to calculate the bottom 3 sales
figures between Jan, Feb and Mar.
A
|
B
|
C
|
D
|
E
|
|
1
|
Sales
|
Jan
|
Feb
|
Mar
|
|
2
|
North
|
$ 5,000
|
$ 6,000
|
$ 4,500
|
|
3
|
South
|
$ 5,800
|
$ 7,000
|
$ 3,000
|
|
4
|
East
|
$ 3,500
|
$ 2,000
|
$ 10,000
|
|
5
|
West
|
$ 12,000
|
$ 4,000
|
$ 6,000
|
|
6
|
|||||
7
|
Lowest
Value
|
$ 2,000
|
=SMALL(B2:D5,1)
|
||
8
|
2nd
Lowest Value
|
$ 3,000
|
=SMALL(B2:D5,2)
|
||
9
|
3rd
Lowest Value
|
$ 3,500
|
=SMALL(B2:D5,3)
|
||
10
|
|||||
No comments:
Post a Comment