Thanks Jim! Almost there for some reason it doesn't work my actual data set.
Any ideas?

Time Value
0 0
5 28600
15 36000
30 28500
60 24000
120 5000
180 1800
240 425
360 50






"Jim Thomlinson" wrote:

Assuming your data starts in cell A1...

=OFFSET(A1, MATCH(MAX(B2:B5), B2:B5), 0)
--
HTH...

Jim Thomlinson


"Jason" wrote:

Time Result
0 0
5 300
10 52000
30 100

So that when the "result" is at a max, the coressponding time is retrived.

Thanks!