Forum Discussion
Bulk summary of granular data
mathetes Thanks, i use pivot tables quite a lot to summarise data but cannot see how this would work for what i would like it to do to group % bandings as i want it to calculate the groups, my spreadsheet layout is very simple as described above but will have 1000 rows down for vehicle column (as that's the fleet size) and the 28-31 additional columns across depending on the days count in the month all with a variable mileage total in each cell.
In the absence of actually having the data to work with--I don't think it should be necessary for me (or anybody else here who'd like to help) to create a data set--my suggestion would be to add a few helper columns or two to reflect those ranges.
But I will go back to my request that you post a copy of the workbook so that I and others can see what works rather than conceptualize in the abstract.
- Thanks, i did manage to get there using a pivot table in the end, i was just requiring a COUNTIF formula to configure the dally mileages into a group that i could pivot the whole sheet on to provide summary & percentage etc.
- Good to hear. It's always better learning when you figure it out for yourself, so great going!
