Tag Archives: maximum

Excel Functions and Formulas

Excel quick tip: Return the cell address of the maximum value in a column

This relatively simple Excel formula returns the address of a cell containing the maximum value in a row of data:-

=ADDRESS(MATCH(MAX(A:A),A:A,0),COLUMN(A:A))

Where the A:A parts of the formula denote the column which contains your data.

Note: Make sure that your formula is entered in a cell in a different column to the data you are searching in otherwise Excel will throw a circular reference error at you.

Note 2: If the maximum value appears twice in your data, the formula will return the cell address of the first instance of the value in the data, from top to bottom.

Note 3:  Replace ‘MAX’ with ‘MIN’ to find the address of the lowest value in your data.