Excel & Sheets practice: Advanced Array Helper Lambdas

Chapter 30 · 4 questions · included in full access

Question 1 · hard
Row-by-row AND with MAP
From K2, spill "Yes" for orders that are Sheets category and have 10+ Units, else "No" — one formula, using MAP so that AND works per row.
Solve it in your browser
Question 2 · medium
Highest regional price
On PriceGrid, spill the highest regional price of each product from G2, using BYROW.
Solve it in your browser
Question 3 · medium
Running revenue total
Spill a running total of Revenue from K2 with SCAN.
Solve it in your browser
Question 4 · hard
Count above average with REDUCE
Using REDUCE, count how many orders have Revenue above the average revenue. Answer in K2.
Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

Row-by-row AND with MAP