Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PivotTable Question | Excel Worksheet Functions | |||
PivotTable Question | Excel Discussion (Misc queries) | |||
PivotTable grouping problem | Excel Discussion (Misc queries) | |||
PivotTable Question | Excel Worksheet Functions | |||
Grouping dates in PivotTable/Chart | Charts and Charting in Excel |