Descriptive Statistic & Basic Maths functions

IMPLODE

Reference

» Reference, Discussion, & Example Applications:

About

Implodes column vectors or an array’s rows, returning a frequency distribution.

Inputs:

  • a : array

Code

M.S. Excel 
IMPLODE = LAMBDA(a,
    LET(
        u, UNIQUE(a),
        HSTACK(
            u,
            BYROW(
                u,
                LAMBDA(x,
                    SUM(
                        --BYROW(
                            x = a,
                            LAMBDA(y,
                                AND(
                                    y
                                )
                            )
                        )
                    )
                )
            )
        )
    )
);