Hi there,
Many thanks in advance for any help/solutions on this (I'm sure) very simple problem from a newbie.
I have a row of numerical data which is updated daily. On a different tab in the same sheet, I want to create a formula with divides the last value in the row by a value in the same row that is a specified number of columns behind the last one.
An example:
<tbody>
</tbody>
I want a formula that takes the last value ("10" on 1/10/13) and divides it by the corresponding value 5 (busines) days earlier (which would be 1/3/13 or "9"), which is easy enough of course. What I want to know is how to get the formula to update automatically, as I enter new values for each day.
I have figured out how to return the last value in a row using =LOOKUP(9.9999999999999+307, row#:row#), which I could theoretically use to get the updated last number in the row. The question is how to get the trailing number.
All the bets and thanks for taking the time!
Jim
Many thanks in advance for any help/solutions on this (I'm sure) very simple problem from a newbie.
I have a row of numerical data which is updated daily. On a different tab in the same sheet, I want to create a formula with divides the last value in the row by a value in the same row that is a specified number of columns behind the last one.
An example:
1/1/13 | 1/2/13 | 1/3/13 | 1/4/13 | 1/5/13 | 1/8/13 | 1/9/13 | 1/10/13 |
10 | 11 | 9 | 12 | 8 | 10 | 9 | 10 |
<tbody>
</tbody>
I want a formula that takes the last value ("10" on 1/10/13) and divides it by the corresponding value 5 (busines) days earlier (which would be 1/3/13 or "9"), which is easy enough of course. What I want to know is how to get the formula to update automatically, as I enter new values for each day.
I have figured out how to return the last value in a row using =LOOKUP(9.9999999999999+307, row#:row#), which I could theoretically use to get the updated last number in the row. The question is how to get the trailing number.
All the bets and thanks for taking the time!
Jim