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