Level 3LET and LAMBDAPractice, 3 min
BYROW: the best month per campaign
The task
In E2, find each campaign's best month of leads with
BYROW. BYROW hands your LAMBDA one whole row at a time.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Campaign | Jan | Feb | Mar | Best month |
| 2 | Brand | 412 | 398 | 455 | |
| 3 | Competitor | 96 | 121 | 133 | |
| 4 | Retargeting | 210 | 187 | 240 | |
| 5 | Webinar | 55 | 140 | 72 | |
| 6 | Partner | 38 | 44 | 51 |