People talk of helper columns, but I have a suggestion with a few helper
worksheets. For convenience the worksheets have been given names. A few
ranges have also been given names:
blok list!$B$3:$Z$51
columnnumbers columnnumbers!$B$3:$Z$51
rownumbers rownumbers!$B$3:$Z$51
unique unique!$B$3:$Z$51
uniquerank 'unique ranks'!$B$3:$Z$51
List
Contains the values in cells B3 to Z51. A3 to A51 are numbered from 1
upwards, and also B2 to Z2.
Ranks
Cell B3: =RANK(list!B3,blok) (copied to B3:Z51)
Unique
Cell B3: =RANK(list!B3,blok) (copied to B3:Z51)
Unique ranks
Cell B3: =RANK(unique!B3,unique) (copied to B3:Z51
Rownumbers
Cell B3: =ROW(A3) (copied to B3:Z51)
Columnnumbers
Cell B3: =COLUMN(A3)
Sheet8
From B1 to F1 the column headings are Row, Column, Value, Unique value, Rank
In column A from cell A2 the cells are numbered from 1 upwards.
Cell B2: =SUMPRODUCT(rownumbers,--(uniquerank=$A2))
Cell C2: =SUMPRODUCT(columnnumbers,--(uniquerank=$A2))
Cell D2: =SUMPRODUCT(blok,--(uniquerank=$A2))
Cell E2: =SUMPRODUCT(unique,--(uniquerank=A2))
Cell F2: =SUMPRODUCT(ranks!$B$3:$Z$51,--(uniquerank=$A2))
Copy the cells down as far as is necessary.

"Mr. Snrub" wrote:

I have a table of integers ranging from cells B3 to Z51, and I want to find
the cell address of the largest value.

=LARGE(B3:Z51, 1) will give me the largest value, but how do I find the cell
address where that largest value is located?