Sign up for our free Insiders program and get the example file:
Click here: https://exceloffthegrid.com/insiders-signup/
File Reference for this video: 0256 Period, YTD & Projection with GROUPBY.zip
★ Want to become an Excel ninja? Check out our training academy ★
https://exceloffthegrid.com/
★ About this video ★
In this video, we explore how to use the GROUPBY function in a scenario where PivotTables aren't up to the job. It shows how ot calculate Period, Year-To-Date, and full year projections using Budget and Actual values in a single output.
The video goes step-by-step through array and boolean techniques to calculate the required output. Even if this isn't your scenario, you can use this method to calculate almost any layout.
0:00 Introduction
0:36 Workbook setup
2:12 Boolean logic
5:12 Using GROUPBY
6:30 Differences and Projections
8:58 Result
9:21 Wrap up
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: https://twitter.com/exceloffthegrid
#MsExcel