Find the smallest order with SMALL
BeginnerSMALL helps you pull a value by rank from the bottom of a list, which is useful when you want more than just the single minimum.
In a sales log, unusually small orders can be worth a second look. They might be test transactions, entry mistakes, or orders that need follow-up. The SMALL function returns the k-th smallest value in a range, where k is the rank you want from the low end.
The basic pattern is:
=SMALL(array, k)
Example:
=SMALL(D2:D10, 2)
What you need to do
The order amounts are in C2:C9. Use SMALL to return the three lowest order amounts.
- Click B11 and enter a formula that returns the smallest amount from the list.
- Click B12 and enter a formula that returns the 2nd smallest amount.
- Click B13 and enter a formula that returns the 3rd smallest amount.
Goal
Cells B11:B13 should show the three smallest order amounts from the sales log in ascending order.
Need some help?
Hint 1
Use the order amounts as the array, not the order numbers or customer names. SMALL needs the numeric values from the sales table.
Hint 2
Point each result cell to the same amount range in column C. In B11 use rank 1, in B12 use rank 2, and in B13 use rank 3.
Find the smallest order with SMALL
BeginnerSMALL helps you pull a value by rank from the bottom of a list, which is useful when you want more than just the single minimum.
In a sales log, unusually small orders can be worth a second look. They might be test transactions, entry mistakes, or orders that need follow-up. The SMALL function returns the k-th smallest value in a range, where k is the rank you want from the low end.
The basic pattern is:
=SMALL(array, k)
Example:
=SMALL(D2:D10, 2)
What you need to do
The order amounts are in C2:C9. Use SMALL to return the three lowest order amounts.
- Click B11 and enter a formula that returns the smallest amount from the list.
- Click B12 and enter a formula that returns the 2nd smallest amount.
- Click B13 and enter a formula that returns the 3rd smallest amount.
Goal
Cells B11:B13 should show the three smallest order amounts from the sales log in ascending order.
Need some help?
Hint 1
Use the order amounts as the array, not the order numbers or customer names. SMALL needs the numeric values from the sales table.
Hint 2
Point each result cell to the same amount range in column C. In B11 use rank 1, in B12 use rank 2, and in B13 use rank 3.