Basic Excel Question - Help Needed

sorry mate I think you are going down the wrong road...

I do it this way (see attached file)

in cells A1:a20 put your data
in cells c1:c9 put your bins (ie what you want to divide the data into - in my examples it is 5's)
i cell d1 use the function button to get "frequency" or type
=FREQUENCY(A1:A20,C1:C9)

then press ENTER

Then drag the formual down to cell d10 then (THIS IS IMPORTANT) press the f2 key then press (at the same time CTRL+SHIFT+ENTER)

This will make an array that contains all the values for each bin with d10 being values > than the last bin

I hope this helps

Mark