CountIF function

M

mdk

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.
 
R

Roger Govier

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.
 
Top