Yes, when there is the exact same value 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? papau's formula don't
seem to work in this case (it repeats the first cell address found when there
is a "tie"), and (as far as I know) MAX only finds the largest value, not the
second-, third- or fourth-largest.

Thanks for all your help, by the way!

Mr. Snrub

"Aladin Akyurek" wrote:

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?

Be aware of the fact that there can be multiple instances of the largest
value. See:

http://tinyurl.com/dph4d