How do I return the value of an adjacent cell?

  • Thread starter Thread starter Kun0
  • Start date Start date
K

Kun0

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.
 
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
 
Another:
=index(a:a,match(max(b:b),b:b,0))

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

=index() is not.
 
Back
Top