finding data relating to max

  • Thread starter Thread starter jimn999
  • Start date Start date
J

jimn999

I have a basic spreadsheet which has increments of seconds in the
column (time) and figures that occured at those times in the b colum
(data). I need to display two figures

1. the max of the b (data) column
2. the relating time this max occured from the a column (time)

Can anyone help
 
Hi

Try this formula =VLOOKUP(MAX(D5:D9),D5:E9,2,FALSE). If you need a
error handeling then this on
=IF(ISERROR(VLOOKUP(MAX(D5:D9),D5:E9,2,FALSE))=TRUE,0,VLOOKUP(MAX(D5:D9),D5:E9,2,FALSE))
Don't forget, should you copy this formula down to include the $.

Good luck with it
 
OK, i typed ion the following

=VLOOKUP(MAX(B1:B60),A1:A60,2,FALSE)

and it comes up with #n/a

have i done something wrong
 
Hi again,

Yes, you've made a type error. But if what I would do to make i
easier is to have, if I may be so bold, the coloms switched aroun
because of the VLOOKUP formula. VLOOKUP looks up in the left colum
and will give the result from the right column. Then use this formul
again
=VLOOKUP(MAX(A1:A60),A1:B60,2,FALSE)

You'll see the range A1:B60 (2 columns). A column is for the MAX and
colum is the result.

Hope you understand what I am trying to explain:)

Stephe
 
Back
Top