![]() |
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 |
All times are GMT +1. The time now is 03:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com