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 work with Excel ...

Value: Explanation: 0: Find an exact match; return #N/A if none found. This is the argument’s default value.-1: Find an exact match; return the next smaller item if no match is found.

There are several new dynamic array functions and over the next few months, we’ll cover several of them. Next up, we’ll be using SEQUENCE() to return the top n values in a data set.

However, if we convert this formula into an array formula by saving it using Ctrl+Shift+Return rather than just Return, it will behave like SUMIF() and perform the ABS() function on each cell in the ...