Practice challenge
Find peak daily demand
#24
3 attempts remaining
BeginnerInventoryTarget G2
A stock planner reviews daily demand for one item.
Write a formula for G2 that returns the largest demand from Monday through Friday.
Find peak daily demand
Swipe horizontally to view the full table.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| # | SKU | Mon | Tue | Wed | Thu | Fri | Peak |
| 2 | TEA-01 | 18 | 24 | 20 | 31 | 27 | blank |
| 3 | MUG-02 | 8 | 12 | 10 | 9 | 14 | blank |
| 4 | KIT-03 | 4 | 7 | 9 | 5 | 8 | blank |