A.I.M. Users Bulletin Board

[SFSecurity]

Hi Gang, I finally found the way to look up the last date in a column! The formula is a bit strange but it works.

=LOOKUP(2,1/(B:B<>""),B:B)

You can adjust which column you are using by changing the "B" to whatever column you need.

BTW, it can also be used to find any ending data that you might want to look at without having to scroll through the whole page.

This is great because I have all the results in the top two lines and don't have to scroll to the bottom of my backtest anymore to see how I'm doing.

Now if I could figure out how to find any negative figure that might occur in the cash column it would make backtesting even easier.