4 integera (with no separators) in each cell of a column range. Counting each individual interger

Vinnie_Smith 

With 365 you can do this a few different ways.

This method 'explodes'  each 4 digit number by converting each to a 1x4 array.  The result of using explode on the entire column is a matrix of numbers 4 columns wide.  TOCOL converts this matrix to a vector and then REDUCE cleans up.

=LET(
    explode, LAMBDA(integer, MID(integer, {1, 2, 3, 4}, 1)),
    number_vector, TOCOL(explode(numbers)),
    unique_numbers, SORT(UNIQUE(number_vector)),
    CountNumbers, LAMBDA(acc, i,
        LET(
            total, SUM(N(i = number_vector)),
            VSTACK(acc, HSTACK(i, total))
        )
    ),
    REDUCE({"Totals", "Count"}, unique_numbers, CountNumbers)
)

This task becomes a bit easier with access to the Insider function GROUPBY:

=LET(
    explode, LAMBDA(integer, MID(integer, {1, 2, 3, 4}, 1)),
    number_vector, TOCOL(explode(numbers)),
    GROUPBY(number_vector, number_vector, COUNTA)
)