Finding Frequency of data

Hi I have a list of 16000 numbers in column A,I want to get only highest 10 frequency numbers in column B1 to B10 and make a histogram .
what changes should I make in this formula to get top 10 frequency ?
=IF(COUNTIF(A$1:A1,A2),0,COUNTIF(A$2:A$16000,A2))


regards

Try using this formula in B1

=MODE(A1:A16000)

then in B2 use

=MODE(IF(COUNTIF(B$1:B1,A$1:A$16000)=0,A$1:A$16000))

confirmed with CTRL+SHIFT+ENTER

That gives you the top 10 numbers - if you want to know how frequently they occur then use COUNTIF in column C, i.e. in C1 copied down

=COUNTIF(A$1:A$16000,B1)

The formula doesn't work with blank rows - as you only have 8000 rows of data the other 8000 blanks are identified as zeroes. Try changing to this version in B2

=MODE(IF(COUNTIF(B$1:B1,A$1:A$16000)=0,IF(A$1:A$16000<>"",A$1:A$16000)))

then copy down again