Replace legacy formulas with MAP, BYROW, BYCOL, SCAN, and REDUCE to build secure, scalable, and automated spreadsheets.
Many of the Excel formulas I use for lists require supervision. Sometimes, when I add a new row, something breaks or needs adjusting. TAKE and DROP don't have that problem. These two dynamic-array ...