Excel
=EXCEL(...)Excel LAMBDA Helper Functions: MAP, REDUCE, SCAN & BYROW
Master Excel LAMBDA helper functions: BYROW, BYCOL, MAP, SCAN and REDUCE for running totals and per-row logic.
Explore ↗
#advanced-formulas
2 formula guides
Google Sheets
=QUERY(...)Advanced QUERY in Google Sheets: PIVOT, LABEL & FORMAT
Go beyond basic Google Sheets QUERY: master PIVOT, LABEL and FORMAT clauses with date filters and nested queries.
Explore ↗