Thanks!!!!!
--
Shirley
"Bob Phillips" wrote:
=INDEX(A10:A14,MATCH(MAX(B10,B14),B10:B14,0))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Shirley" wrote in message
...
If someone could help me, I would really appreciate it! I am using the
LARGE
function to return certain values from a list of numbers. For example, I
have the following data:
JAN 100
FEB 150
MAR 200
APR 175
MAY 180
In part of a spreadsheet, I have LARGE(($B$10:$B$14),1) which returns the
highest value, 200. What I am trying to do next is have data from the
corresponding row be returned. For example, I want MAR returned in the
cell
next to the LARGE formula above. I tried to do this by turning on the
R1C1
function, and inserting the formula into the reference, but it is taking
the
result as the row, not using the result's row as the reference. (is that a
a
tongue twister?)
Anyway, if someone could tell me how to do this, it would save me hours of
manually inserting data!!!!
Thanks to any who take the time to respond!!
--
Shirley
|