Descriptive Statistic & Basic Maths functions

MAPX

Reference

» Reference, Discussion, & Example Applications:

About

MAP Expander.

Expands all its array arguments into arrays so they have the same dimensions, and indexes them using “n”.

Inputs:

• n : array’s index nr., 1, 2, 3 or 4
• a : array
• b : array
• [c] : array, if omitted n can be 1 or 2.; not omitted n can be 1, 2, or 3
• [d] : array, if omitted n can be 1, 2 or 3; not omitted n can be 1, 2, 3 or 4

Code

MAPX = LAMBDA(n, a, b, [c], [d],
    LET(
        w, MAX(
            ROWS(a),
            ROWS(b),
            IFERROR(ROWS(c), 0),
            IFERROR(ROWS(d), 0)
        ),
        l, MAX(
            COLUMNS(a),
            COLUMNS(b),
            IFERROR(COLUMNS(c), 0),
            IFERROR(COLUMNS(d), 0)
        ),
        p, LAMBDA(x, IFNA(EXPAND(x, w, l), x)),
        SWITCH(n, 1, p(a), 2, p(b), 3, p(c), 4, p(d))
    )
);