View Single Post
  #2   Report Post  
Jim Thomlinson
 
Posts: n/a
Default

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!