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 ...

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 VBA module with functions for (VBA) arrays. Contribute to VBA-tools2/modArraySupport2.vba development by creating an account on GitHub.

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

You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP (), you now have more power and less confusion.