A formula that uses the last piece of valid data in a column

[N.N.Jineer]

I have searched dozens of messages in this forum and found what is apparently half of the answer to my question. However I need the other half.

I know various ways to find the reference of the cell that has the last piece of valid data in a column, but I don't know how to then include that in a formula. Let me provide an example.

Column A is Date
Column B is a stock price
Column C is another stock price

I want to create a formula that gives me the percent difference between the FIRST date in my data and the last date in the data. I'm currently using:

=B35/B3-1
=C35/C3-1

Then after today's stock prices are entered in the sheet I'll change it to 36, then the next day 37.

How do I use something like the MATCH or ADDRESS command and incorporate it into this formula?

 

[stanleydgromjr]

Please post examples of the data in columns A, B, and C.

Post a shot of your sheet with Colo's HTML Maker.
http://www.mrexcel.com/board2/viewtopic.php?t=92622

Have a great day,
Stan

 

[SydneyGeek]

Hi, and welcome to the Board!

Try:
=LOOKUP(9.9999999E+307,B:B)/B3-1
Similar for column C.

Denis