How do I return the value of an adjacent cell?
 

I have two data colums.. one with a date and another with a statistic. I want
a formula that returns the date of the all time high of the statistic.

How do I return the value of an adjacent cell?
 

Assume the dates are in column A and the stats are in column B

=INDIRECT("A" &MATCH(MAX(B:B),B:B,0))

For example:

11/14/2008 48
10/19/2008 26
10/25/2008 42
10/19/2008 46
10/22/2008 94
10/11/2008 62
11/20/2008 92
10/6/2008 85
10/8/2008 32
10/15/2008 38

the formula gives 10/22/2008

--
Gary''s Student - gsnu200816


"Kun0" wrote:

I have two data colums.. one with a date and another with a statistic. I want
a formula that returns the date of the all time high of the statistic.

How do I return the value of an adjacent cell?
 

Another:
=index(a:a,match(max(b:b),b:b,0))

=indirect() is volatile function--it'll recalculate whenever excel recalcs.

=index() is not.

Kun0 wrote:

I have two data colums.. one with a date and another with a statistic. I want
a formula that returns the date of the all time high of the statistic.

--

Dave Peterson