The Motley Fool Discussion Boards

Previous Page

Investing/Strategies / Retirement Investing


Subject:  Re: Hi gang... wow!!! Date:  4/23/2013  9:36 AM
Author:  MurrayS Number:  72103 of 99742

Let's say the date is in column A, price in B, recent peak in C, date of recent peak in D.

In cell C11, you would have the formula: {=MAX(IF($A$2:A11>D10,$B$2:B11,0))} (use ctrl-shift-enter to make it an array formula as indicated by the {})

In cell D11, you would have the formula: =INDEX($A$2:A11,MATCH(C11,$B$2:B11,0))

Something like that should work. You may need to put in a valley since really, you're looking for the peak after the valley.

Copyright 1996-2020 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us