J
John Taylor
Hello,
I would appreciate some help in developing two formulas to look up the
maximum value (Stock Market Index) between a range of dates, and show the
date and the matching Index value.
If the dates are in ascending order in Column A, and the indices are in
Column B, if I put the first date in cell J3 and the second date in cell J4,
what formulas will give me the maximum Index value between those two dates
and the date on which it was recorded?
Jumping the gun a bit, but if there a several dates with the same maximum is
it possible to have the formula return that figure and all the dates on
which they were recorded?
For example (dates are in dd/mm/yyyy format):
Col A Col B
02/01/2007 5670.2
03/01/2007 5649.3
04/01/2007 5584.8
05/01/2007 5572.0
12/09/2007 6220.3
13/09/2007 6230.6
14/09/2007 6306.8
17/09/2007 6271.4
27/12/2007 6350.9
28/12/2007 6339.9
31/12/2007 6339.8
If I enter 01/01/2007 in J3 and 31/12/2007 in J4, I would like the formulas
to return:
27/12/2007 and 6350.9
Any help will be most appreciated.
Regards,
John
I would appreciate some help in developing two formulas to look up the
maximum value (Stock Market Index) between a range of dates, and show the
date and the matching Index value.
If the dates are in ascending order in Column A, and the indices are in
Column B, if I put the first date in cell J3 and the second date in cell J4,
what formulas will give me the maximum Index value between those two dates
and the date on which it was recorded?
Jumping the gun a bit, but if there a several dates with the same maximum is
it possible to have the formula return that figure and all the dates on
which they were recorded?
For example (dates are in dd/mm/yyyy format):
Col A Col B
02/01/2007 5670.2
03/01/2007 5649.3
04/01/2007 5584.8
05/01/2007 5572.0
12/09/2007 6220.3
13/09/2007 6230.6
14/09/2007 6306.8
17/09/2007 6271.4
27/12/2007 6350.9
28/12/2007 6339.9
31/12/2007 6339.8
If I enter 01/01/2007 in J3 and 31/12/2007 in J4, I would like the formulas
to return:
27/12/2007 and 6350.9
Any help will be most appreciated.
Regards,
John