The Motley Fool Discussion Boards

Previous Page

Investing/Strategies / Retirement Investing

URL:  http://boards.fool.com/thats-because-i-cant-figure-out-how-to-make-30648362.aspx

Subject:  Re: Hi gang... wow!!! Date:  4/23/2013  12:17 AM
Author:  synchronicityII Number:  72101 of 75340

That's because I can't figure out how to make Excel find the "most recent high value", since excel searches don't really like to look backwards, only forwards.

=Max(A1:A27).

Substitute whatever cells you are actually checking for "A1:a27". For what it's worth, I use this on the Case-Schiller housing index spreadsheets to quickly check drop from peak, and use the Vlookup function in conjunction with that to determine the month in which that peak occurred.

-synchronicity, spends way too much time in Excel.
Copyright 1996-2014 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us