D
dbasmb
I have temperature data for many years and am trying to find the minimum
temperature for a given day. I can find the min temperature on a given day
with this:
{=MIN(IF(TEXT($A$7:$A$2001,"mmm,d")=X127,$D$7:$D$2001))} where X127 has the
day of the month I'm searching for and the low temperatures are in column
"D". But now I want the day it occurred which is in column "A" of the same
row as the min temp. How do I get that? I thought this would work;
{=ADDRESS(ROWS(D72001=Z127),1)} but that gives me an erroneous address.
Another question: If I have the correct result from the 'ADDRESS()'
function above, how do I access the data in that cell that is referenced as a
text value?
Thanks for your help!
Doug
temperature for a given day. I can find the min temperature on a given day
with this:
{=MIN(IF(TEXT($A$7:$A$2001,"mmm,d")=X127,$D$7:$D$2001))} where X127 has the
day of the month I'm searching for and the low temperatures are in column
"D". But now I want the day it occurred which is in column "A" of the same
row as the min temp. How do I get that? I thought this would work;
{=ADDRESS(ROWS(D72001=Z127),1)} but that gives me an erroneous address.
Another question: If I have the correct result from the 'ADDRESS()'
function above, how do I access the data in that cell that is referenced as a
text value?
Thanks for your help!
Doug