First, we need to type Sheet2!A1 into cell A3, and then we need to turn this into a reference using the INDIRECT function by ...

Excel's AGGREGATE function works with vertical ranges only, not horizontal ranges. So, when you reference a horizontal range, AGGREGATE will not ignore rows in hidden columns.

How to use VBA’s InputBox function to select a range on the fly in Excel Your email has been sent Often, you’ll want Excel users to specify a range that the app then uses in an automated way ...

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel. Skip to content. ... Ref1, which is required, is the range of data to apply the function. Array, which is ...

The function often takes cell references as input, letting you easily apply the function to each cell in a range. Alternatively, you can type out the input in the form of an alphanumeric mix.