Excel Guides

Finding the Address of the Lowest Value in a Range in Excel

To find the address of the lowest value in a range in Excel, you can use the ADDRESS function. This function takes two arguments: row_num and column_num. The row_num argument is the row number of the cell that you want to return the address for. The column_num argument is the column number of the cell that you want to return the address for.

You can use the ADDRESS function in a formula to return the address of a cell in a worksheet. For example, if you have a range of cells in A1:A5 and you want to find the address of the cell with the lowest value, you can use this formula:

=ADDRESS(MIN(A1:A5),1)

This formula will return the address of the cell in column A that has the lowest value. You can also use this function to return the address of a cell in a named range. For example, if you have a named range called "MyRange" that consists of cells in A1:A5, you can use this formula to find the address of the cell with the lowest value:

=ADDRESS(MIN(MyRange),1)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.