Array Manipulation Functions
Table of Contents How to use the CHOOSECOLS function How to use the CHOOSEROWS function How to use the DROP […]

Get date ranges from a schedule
This article demonstrates ways to extract names and corresponding populated date ranges from a schedule using Excel 365 and earlier […]

How to use the IFNA function
What is the IFNA function? The IFNA function handles #N/A errors only, it returns a value you specify if the […]

SUMPRODUCT if not blank
This article describes ways to work with the SUMPRODUCT function and blanks, error values, N/A# errors. Table of Contents SUMPRODUCT […]

Lookups in relational tables
Excel 2010 has a PowerPivot feature and DAX formulas that let you work with multiple tables of data. You can […]

Filter unique distinct records
Table of contents Filter unique distinct row records Filter unique distinct row records but not blanks Filter unique distinct row […]