00:00Just a quick public service announcement here.
00:02Microsoft recently released Group by Function exclusively for Microsoft 365 Insider.
00:07If you don't have access to Microsoft 365 Insider, no problem.
00:11I've created a version for you.
00:12Group by Function, by the way, is used to group rows with similar values
00:16so that aggregate functions like sum and count can be applied.
00:20To use my Group by Function, first press Alternate F11 to open VBA Editor.
00:24Right-click on Module, Insert Module, and paste this VBA script in your new module.
00:29Let me know if you need the VBA script.
00:31Then press Control-S to save and close the VBA Editor.
00:33Let's test the Group by Function with the 10 built-in Aggregate Function.
00:37The first one to be tested is a Group by with the aggregation function of sum.
00:41After that, average, standard deviation for population, standard deviation for sample,
00:45variant for population, variant for sample, maximum value, minimum value,
00:51mean average deviation, percentage of, quartile exclusion, quartile include, count, and median.
00:59The next one is a Group by Function.
00:59It is a Group by Function.
00:59The next one to start is a Group by Function.
Comments