GROUPBY Function The Basics and Beyond
Until recently, creating a Pivot was the easiest way for summarizing data.
With the introduction of the GROUPBY function we can now create these summary reports and have them update automatically without the need of refreshing manually.
In this tutorial, I explain how to use the GROUPBY function either with lists, with Tables or with named Ranges. I then go beyond the basics to make it interactive by using Drop Lists.
So, let’s dive in.