Don't let the MAX() in the formula fool you!

Manually enter *ANY* value in J1, and you'll see that you'll still get your
labels.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Diane Alsing" wrote in message
...
That works great, but my poor description was a little off ;-( More
clearly
what I need to do is find a specific value from the matrix that may not be
the MAX value, and return the column & row - Thank you!

"Frank Kabel" wrote:

Hi
try the following to array formulas (entered with cTRL+SHIFT+ENTER):
=INDEX(A1:G1,MAX(IF(B2:G7=J1,COLUMN(B2:G7))))
and
=INDEX(A1:A7,MAX(IF(B2:G7=J1,ROW(B2:G7))))

--
Regards
Frank Kabel
Frankfurt, Germany
"Diane Alsing" schrieb im
Newsbeitrag ...
I have a matrix I have created in Excel. I am using this for
correlations.
I have cells B1 through G1 filled with text names (the same values as
A2
through A7). In the matrix fields I calulate their correlations. In
a
seperate field, say J1, I am calculating the highest correlation value
from
my matrix. What I would like to do in cells K1 and/or L1 is find the
corresponding text names for that high correlation. So for example if
cell
E1 is Red and cell A2 is Magenta and their correlation is .95, the
highest
in
the matrix, Cell J1 calculates .95. I would like cell(s) K1 and/or L1
to
return Red Magenta.

Hope this makes some sense - Happy New Year
Regards,
Diane