Forum Discussion
Ryansmills1840
Jun 14, 2023Copper Contributor
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...
Ryansmills1840
Copper Contributor
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.
mathetes
Jun 16, 2023Silver Contributor
Good to hear. It's always better learning when you figure it out for yourself, so great going!