LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GMW GMW is offline
external usenet poster
 
Posts: 1
Default Last value in row

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)?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"