How to identify the 10 most common numbers in Excel?

Question

excel

Hello.
There is an Excel table with a column of several thousand cells. 1 cell in this column = 1 number. How to calculate the TOP 10 most common numbers and display them?
Thank you!
Ps work in progress in Office 365 for MacOS.

Answer 1

If you do not write code in VB, then the algorithm is as follows:
copy, remove duplicates, apply the countif function, sort.

Answer 2

do the following:
create a pivot table.
We enter the column we need in the rows and values
​​In the values, select the number
In the row filter, select the filter by value-> TOP 10