Forum Discussion
Bulk summary of granular data
Hi All, I'm looking for some help/advice to consolidate/group granular data, my example is daily vehicle mileage over a months period, Column A would have vehicle registration numbers and then f...
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!