Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

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

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.

In this guide, we'll go through five different examples of how to use IF and VLOOKUP nested functions in Excel.

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