ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   PivotTable question about grouping numbers in it (https://www.excelbanter.com/excel-worksheet-functions/149333-pivottable-question-about-grouping-numbers.html)

Ivica TypeR

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