Find the date question

  • Thread starter Thread starter Skip
  • Start date Start date
S

Skip

I have a spreadsheet with various numerical data series in columns. The
first column is the date. Rows are in date order oldest at top, recent at
bottom.

Elsewhere on the spreadsheet I would like to create a formula which reports
the date (as detailed in column A) that the highest numerical value in say
column B occured. I would also like to repeat this for the lowest numerical
value. I have been playing around for a while, but just can't find the
answer. Can anyone help?
 
Try

=INDEX($A:$A,MATCH(MAX($B:$B),$B:$B,0),0)

And

=INDEX($A:$A,MATCH(MIN($B:$B),$B:$B,0),0)

HTH,
Andy
 
Skip,

Assuming your data area is in A1:B25 (dates in A; value in B), use :

=INDEX(A3:A27,MATCH(LARGE(B3:B27,1),B3:B27,0)) for the maximum and :

=INDEX(A3:A27,MATCH(SMALL(B3:B27,1),B3:B27,0)) for the minimum

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top