Small Excel Formula

What is the use of Small formula?

Finds the nth smallest number in a list

Syntax of Small formula:
small(from this list, nth smallest number)

Examples of Excel Small formula:
small(list, 2) = 2nd smallest number in the list


Buy Excel Formula E-book | Learn more about Excel Small Formula

More Logical & Reference Functions : And | Countblank | Countif | If | Large | Max | Min | Not | Or | Small | Sumif | Vlookup

Mathematical Functions | Text Functions | Logical & Reference Functions
Date & Time Functions | Financial Functions | Information Functions