J
J
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
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