I have this data set which needs to be grouped by data in the first two columns, but also with a sum within each grouping.
The attached file has a before and after.
I have this data set which needs to be grouped by data in the first two columns, but also with a sum within each grouping.
The attached file has a before and after.
Run the code and lookat sheets(2).
![]()
Please Login or Register to view this content.
Harry.
Hi -
Also try;
Regards,![]()
Please Login or Register to view this content.
Event
try
![]()
Please Login or Register to view this content.
Hi Jindon -
Nice approach
much faster by 1.5 seconds running a test of 500000 records compared to mine.
Regards,
Event
Thank you to all...the solutions are great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks