Thread: Pivot Grouping
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Donica Donica is offline
external usenet poster
 
Posts: 15
Default Pivot Grouping

Pivot Table Grouping
If I have a defined grouping based on a set of number e.g. Field 1="Group"
Field2="Code"

Group Code
Group One = 23453
56773
23456

Group Two = 33333

When a new number is added to the pivot table data source €“ Code field
How can I group it into Group One without manually re-grouping?

Ideally an if statement to say if Code is not = to (<) 33333 then Group One,
But I dont know how to write it and more importantly where to put it.

--
Regards,

Donica