Theory:
=SMALL(Range,Number)
Example:
=Small(A2:A9,2)
The SMALL function displays the smallest or lowest value from a range based on the number value written after the range reference. The number 2 in the formula above states that the formula should display the 2nd to last (or 2nd smallest) value from range A2 to A9. A number 1 would denote to display the last or 1st smallest value. The number 3 would denote to display the 3rd to last or 3rd lowest value and so on.
=SMALL(Range,Number)
Example:
=Small(A2:A9,2)
The SMALL function displays the smallest or lowest value from a range based on the number value written after the range reference. The number 2 in the formula above states that the formula should display the 2nd to last (or 2nd smallest) value from range A2 to A9. A number 1 would denote to display the last or 1st smallest value. The number 3 would denote to display the 3rd to last or 3rd lowest value and so on.
0 comments:
Post a Comment