ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Grouping difference between 2003 and 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/262752-grouping-difference-between-2003-2007-a.html)

Wes D

Grouping difference between 2003 and 2007
 
In Excel 2003, when you right clicked a numeric field, and selected group...
you would be given a dialog where you could enter the start, end and
increment for the PivotTable.

In 2007, Group does not present any dialog, and instead complains that it
can not group the field. If the entire set of data is selected, it places it
into a single group.

Is there similar functionality in Excel 2007? How can you set up a group by
increment without doing the grouping by hand?



All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com