"Ron Rosenfeld" wrote...
With the range in which the numbers are stored named "rng" (or you
may substitute the cell reference directly in the formula, the
following **array** formula will give you the cell address of the
first cell to contain that maximum value.
....
=ADDRESS(MAX((rng=MAX(rng))*ROW(rng)),
MAX((rng=$A$1)*COLUMN(rng)))

This will work for ranges comprising multiple rows/columns as well as
for ranges which are just a single row or column.

However, the range may not include more than 65,535 cells.
....

Multiple inaccuracies. Last first - rng can't span entire columns, but could
span 65,535 rows in multiple columns. Won't be fast to recalc, but will
work.

Secondly, this could return incorrect results when there are multiple
instances of the maximum value, e.g., A1:C4 containing

2 1 8
3 4 5
6 7 3
8 5 0

If that were rng, your formula would return $C$4, which happens to be the
minimum value.

Searching 2D ranges *REQUIRES* specifying whether to search along columns
then rows or along rows then columns. Also, formulas calling ADDRESS are
overly redundant. CELL("Address",INDEX(rng,...)) is the way to go.