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

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