Summarizing

[aftershokk]

I have 20,000 rows of percents.

I want to perform an easy breakdown:
example: -.20% to .29% = count = 500 items
.30% to .90% = count = 756 items
and so on and so on
help!

 

[just_jon]

What ranges exactly do you want to count? And, the range of say 30% to 50% -- does that include 30% & 50%, or are they greater than/less than ranges?

 

[aftershokk]

ranges
between 30-50 = 785
51-100 = 800
and so on

 

[Mark W.]

Unequal intervals?

 

[aftershokk]

intervals that I specify; probably 8 0r more ranging from -.28 and under and up to +300%

 

[aftershokk]

also I pasted my percents to values and now I see
1.23119325990448 in each cell
I need it to be two decimal places in the cell also, not just the display
thanks,