Assume your data in A1:A15
Create a Bin range
B1: 9
B2: 20
B3: 30
B4: 40
B5: 50
B6: 1000

Highlight blank cells C1:C6 then enter formula: =FREQUENCY(A1:A15,B1:B6)

ctrl+shift+enter, not just enter



"mark (plymouth)" wrote:

Hi All,
i am trying, without success to creat a formula to do the following:
i have a series of values in a column and want to show how manay time a
number occurs within a range from the list.
i.e. in my list i have 12,17,23,24,25,23,24,22,26,43,32,32,33,44,53
i then want to display the number of instance there is an occurance of:
<10, 10-20, 21-30, 31-40, 41-50, 51
I would appreciate any assitance you might offer.

Thanks