Dear Dave,

I think i din't get my question asked nicely ...

Lets start again.

I have a series of data:
1,1,1,2,2,2,3,3,4,4

Under normal circumstances, if i want to group the data as table below, it
would like this:

Value range Occurence
1-2 =COUNTIF(A1:A10,"=1") -
COUNTIF(A1:A10."2")
2-3 =COUNTIF(A1:A10,"=2") -
COUNTIF(A1:A10."3")

And what if i want a table as per below which allow user to key in their
lower & upperlimit and i can get the occurence ultimatly as above

Value Range Occurence
lower Upper
1(user key in) 2(user key in) =(*need formula here*)
2(user key in) 3(user key in) =(*need formula here*)


Hope i get it clear.
Hope to hear from your favorable response soon.
Thanks!

-Chan