Debra - Thanks very much for responding so quickly. The project is calling
for the groupings to be as follows:

4-4.49
4.5 - 4.99
5.0 - 5.49
5.5 - 5.00

When I use .50, I get the following columns:

4 - 4.5
4.5 - 5
5 - 5.5
5.5 - 6

Any ideas?

Thanks again for your assistance.

Susan


"Debra Dalgleish" wrote:

You should enter .5 as the By value, and the groups will be:

4-4.5
4.5-5
5-5.5
5.5-6


Susan_GW wrote:
I'm trying to group columns in a pivot table according to

4-4.49
4.50 - 4.99
5.0 - 5.49
5.50 - 6

In the grouping box I enter 4 as my start at and 6 as my end, with .49 as
the By. Doing so causes the following column heads to appear:

4-4.49
4.49-4.98
4.98-5.47
5.47-5.96

I'm sure it's something obvious that I'm missing. Any ideas?

Much appreciated,

Susan





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html