» Retrieving the Cell Address of the Largest Value in a Range
Retrieving the address of the cell that contains the largest value within Range1 (A2:D7).
Use the ADDRESS, SUM, IF, MAX, ROW, and COLUMN functions as shown in the following Array formula:
To apply Array formula:
Select the cell, press and simultaneously press .