Oops. I didn't see that.

I'd use a second worksheet and use that to determine the ranks of each value
(with a little fudge factor added to each to make each unique).

I put my test data in A1:C3 of sheet1:

5 5 5
7 6 8
3 9 1

I put this formula in A1:C3 of Sheet2:
=RANK(Sheet1!A1:C3,Sheet1!$A$1:$C$3)
+ROW(Sheet1!A1:C3)/1000+COLUMN(Sheet1!A1:C3)/1000000

(It just adds a little bit to each _integer_ value in that range)

5.001001 5.001002 5.001003
3.002001 4.002002 2.002003
8.003001 1.003002 9.003003

Then this array formula worked ok (on the helper sheet):
=ADDRESS(MIN(IF($A$1:$C$3=LARGE($A$1:$C$3,2),ROW($ A$1:$C$3))),
MIN(IF($A$1:$C$3=LARGE($A$1:$C$3,2),COLUMN($A$1:$C $3))))

If it were me, I'd use the exact same range addresses on both the "real"
worksheet and the "helper" worksheet.

(Yes, this breaks if there are existing decimal values that could interfere with
my fudge factor.)



wrote:

To repeat Senor Snrub :

"Also, when there are the exact same values in two different cells, I
want to
be able to find both cell addresses. For example, LARGE(B3:Z51, 3) will
find
the third-largest value, and LARGE(B3:Z51, 4) will find the
fourth-largest
value. If those two values are the same, how do I find their
corresponding
addresses?"

I can sympathize ; I've struggled just the same. Regards.

--

Dave Peterson