Hi,

Maybe an example of the data would help but the formula would be:
if the first value in the row is in column 2 then:

=INDIRECT("R"&ROW()&"C"&COLUMN()-1,FALSE)/INDIRECT("R"&ROW()&"C2",FALSE)

change the 2 in "C2" at the end to "C1" if it is really the first column or
some other column.


--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"GMW" wrote:

I'm tracking stock prices, and enter daily closing prices for stock symbols
listed in a column. Each row contains daily closing prices. The final
column (once I've got the formula sorted out) is the %age change from the
first value in the row.

How do I designate the last value entered, divided by the first value in
that row? After specifying the first value in the row, End Right seems to go
to the last entered value in that row. How do I enter a formula in the
Percentage Change column to divide the last value in the row by the first
value in that row (-1)?