Hello,
If you copy
=INT(RAND()*100+1)
into cells A1:A1000 and then select cells B1:C20 and array-enter
=Gsort(Pfreq(A1:A1000),"DD","NN","21")
you will get the 20 most frequent numbers (numbers and their frequency
sorted descending)
With
=Gsort(Pfreq(A1:A1000),"DD","NN","12")
array-entered you will get the 20 highest numbers and their frequency.
GSort and Pfreq are UDF's which you can find he
http://sulprobil.com/html/pfreq.html
http://sulprobil.com/html/sort_vba.html
If are generally interested in random number generation:
http://sulprobil.com/html/random_numbers.html
Regards,
Bernd