Spill Functions

>Tag:Spill Functions

Excel Dynamic Array Functions for Dashboard Reporting

Excel Dynamic Arrays for Dashboard Reporting Everyone reading this has most likely heard of Excel Dashboards.  If you are an Excel programmer, you should have heard of the new Dynamic Array Functions.  Knowing how to properly leverage these functions will greatly simplify your Excel programming.  Here we show how to use a few of the [...]

Excel Transpose Methods Then and Now

Excel Transpose Methods Then and Now Microsoft Excel programmers have long used the PasteSpecial Transpose method to Transpose (Pivot) their data.  While very useful, it is a manual process and such it does take more effort than desired. But that was then, this is now, and transposing Excel data just got much easier with the [...]

Using VStack to Consolidate Excel Datasets

Using Excel VStack to Consolidate Datasets Let's start with this, why would you want or need to consolidate datasets in Microsoft Excel?    Because your Excel programmer decided to place like data across multiple tabs and multiple workbooks. They could have just as easily if not more easily, put all of the data in one [...]