This Excel lambda function creates a simple frequency table for a single-column array

excel-lambda-FREQ.SIMPLE.txt

/*
FREQ.SIMPLE

Calculates a simple frequency table of the values in a column

Inputs:
1. data - a single column of data
*/

FREQ.SIMPLE = LAMBDA(data,
    LET(
        d, INDEX(data,,1),
        u,  UNIQUE(d),
        X,  N(u = TRANSPOSE(d)),
        Y,  SEQUENCE(ROWS(d), 1, 1, 0),
        mp, MMULT(X,Y),
        c,  CHOOSE({1,2}, u, mp),
        SORT(c, 2, -1)
    )
);