View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ivica TypeR Ivica TypeR is offline
external usenet poster
 
Posts: 18
Default PivotTable question about grouping numbers in it



in excel sheet i have a lot of numbers, and i want to do pivot table
from this numbers but to be sorted in some range of numbers and to see
it in pivot table in that range! example:
1,09-1,20
1,20-1,60
1,60-1,80
1,80-1,89
1,89-2,60 ....
so to have it all sorted in this kind of ranges and not like pivot data
is arrange by this intervals. Automatically data is now sorted like this:
1,09
1,1
1,11
1,12
1,13
1,14
1,15 .... which is too much rows in pivot table