Have you tried using the Histogram function that's part of the Analysis Tool
Pack?

"J" wrote in message
...
I have some data such as this:

A B
0 .1
1 .3
2 .2
3 .24
4 .18

and i have created a pivot table with this info. i was wondering if there
is
a way to organize the table so that it separates all information from B
into
groups of .1 - .19, .2-.29, .3-.39 ... etc.

if this is possible, i'd like to also count how many cells fall into each
group. i've tried the count option and total option, but i cant seem to do
it
right. any help would be great. thanks in adnvance