Top n most common entries in an array of numbers and how often they occur

BF_UK 

This will also discount any null strings ("") present within the range:

=LET(
    ζ,B1:D1000,
    TAKE(SORT(IF({0,1},FREQUENCY(ζ,0+(0&ζ)),TOCOL(ζ)),2,-1),10)
)

BF_UK 

My solution is similar to the others

= LET(
    occurrences, TOCOL(COUNTIFS(array#,array#)),
    valuesList,  TOCOL(array#),
    sorted,      SORT(HSTACK(valuesList, occurrences),{2,1},-1),
    TAKE(UNIQUE(sorted),10)
  )

The most significant differences are that I applied COUNTIFS to the 2D array whilst is was still a Range and only then reduced the results to a column.  I used LET to avoid excessive function nesting but did not place the formula within a LAMBDA despite the fact that I am moving in that direction.

I also noticed the use of FREQUENCY as an alternative to COUNTIFS.

= LET(
    list,        TOCOL(array#),
    distinct,    SORT(UNIQUE(list)),
    occurrences, DROP(FREQUENCY(list, distinct),-1),
    sorted,      SORT(HSTACK(distinct, occurrences),{2,1},-1),
    TAKE(sorted, 10)
  )

That also seems to work well.

BF_UK 

My solution:

matrix is the 1000x3 array.

'Vector
=TOCOL(matrix)

'Total' Lambda - run each of the numbers through a filter to obtain the counts. Stack, sort, and take top 10.

=LAMBDA(a,v,LET(
    filtered, COUNT(FILTER(vector, vector = v)),
    stack, VSTACK(a, HSTACK(v, filtered)),
    TAKE(SORT(stack, 2, -1), 10)
))

Sheet level formula:

=REDUCE({"Number","Count"},UNIQUE(vector),Total)

Try

=LET(Liste,SEQUENCE(MAX(A2:C1001),,MIN(A2:C1001)),TAKE(SORT(VSTACK(Liste,FREQUENCY(A2:C1001,Liste)),2,-1),10))

BF_UK