View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Grouping a range in pivot without standard to from

Yes, but what do you want to do? In other words what is the question?

--
Thanks,
Shane Devenshire


"MG" wrote:

On the pivot table, I want to gropu a range.I do see an option of grouping it
is based on some range but can define only one "By". for example give me
range for 1-100 and split it in "By"- 10, this means, the range will be 1-10
, 10-20 etc...