Here is an example using equally spaced bins. Say we have values from 0 thru
99 in column A in cells A1 thru A1000 and the bins a

0-9 1
10-19 2
20-29 3
30-39 4
40-49 5
50-59 6
60-69 7
70-79 8
80-89 9
90-99 10

In B1 enter:
=ROUNDDOWN(A1/10,0)+1 and copy down
each value in A has the bin number next to it.

In C1 enter:
=COUNTIF(B1:B1000,ROW()) and copy down thru C10
C1 thru C10 tell you how many values are in each bin.

--
Gary''s Student - gsnu200769


"Paul" wrote:

i have a set of 10 bin ranges i need to calculate the frequnecy that a set of
numbers occur, i tried using the freqency function but cant get it to work
correctly