CountIF function
 

How does one get to arrange in numerical order How many times each number
occurs from a large column and rows of numbers?
Thanks for any help.

Assuming your data is in A1:G100
In H1:H10 enter the number 1 to 10
in I1 enter the formula =COUNTIF($A$1:$G$100,H1)
Copy this formula down I2:I10

This will give a count of the numbers 1 to 10 within the range of data.
Amend range and values to suit.
--
Regards
Roger Govier
"mdk" wrote in message
...
How does one get to arrange in numerical order How many times each number
occurs from a large column and rows of numbers?
Thanks for any help.