View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan_GW Susan_GW is offline
external usenet poster
 
Posts: 3
Default Pivot table grouping

Bob -

Thanks very much for your quick help. When I try this approach, I get the
following groupings:

4-4.49999999999
4.49999999999-4.99999999998
4.99999999998-5.49999999997
5.49999999997-5.99999999996

I think I'm still missing something obvious. This project is calling for the
groupings to be

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

"Bob Umlas" wrote:

try using .49999999999
"Susan_GW" wrote in message
...
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