Excel VBA module with functions for (VBA) arrays. Contribute to VBA-tools2/modArraySupport2.vba development by creating an account on GitHub.

Array Functions This Module is a list of functions that I use to make working with arrays in VBA easier. I will continue to add more functions to this Module. Tested in Windows Excel 2016, but should ...

Excel doesn't have a built-in AVERAGEIF() function, but you can still average values, conditionally.

Among all the exciting announcements made at Ignite last week, one you may have missed (even in all the Excel-related announcements here) was that dynamic arrays have finally reached GA. Ever since ...

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.