The Motley Fool Discussion Boards

Previous Page

Investing/Strategies / Retirement Investing

URL:  http://boards.fool.com/lets-say-the-date-is-in-column-a-price-in-b-30648744.aspx

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

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.

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