G
Guest
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
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