R1C1 Formula help

Hey,
I am trying to write a formula that calculates percentage change of the values of a column. My problem is that I want to select the last value in the column rather than always a specific row. The number of values in the columns varies. I was wondering how to do that.

The current code is:

Please Login or Register  to view this content.

Thanks for your help

Perhaps this will work. It enters a value, not a formula (though this can be changed). It finds the last number in column B and subtracts cell B2 from that value. It then divides that difference by cell B2. The calculated value is put in column B, two rows below the last value.

Please Login or Register  to view this content.

You just need to change the column letter reference from "B" to some other column.