In this guide, you will learn how to use Excel's advanced formulas such as INDEX-MATCH, OFFSET, and INDIRECT to enhance your data analysis capabilities.

The expression we’re going to use combines CountIf () and Offset (). The Offset () function returns a range that’s evaluated by the CountIf (). Enter the following expression in G3 (Figure C).

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.