Moving cell reference
 

I have 4 sheets each containing a running balance that as a transaction is
posted the balance moves to the next cell down. Example: balance is currently
in F4, I make a post that will change that balance and it will now be
displayed in F5.I want to have a summary sheet that will show the current
balance for all 4 accounts. Per some of the other posts regarding dynamic
ranges I've been trying to use
=offset(sav1!$F3,0,0,counta($F:$F),1) I've also tried the same but using
match(9999999,$F:$F) instead of count and still I am not getting the current
balance. Any help would be greatly appreciated.

Moving cell reference
 

Check out this link...

http://www.xldynamic.com/source/xld.LastValue.html
--
HTH...

Jim Thomlinson


"David M" wrote:

I have 4 sheets each containing a running balance that as a transaction is
posted the balance moves to the next cell down. Example: balance is currently
in F4, I make a post that will change that balance and it will now be
displayed in F5.I want to have a summary sheet that will show the current
balance for all 4 accounts. Per some of the other posts regarding dynamic
ranges I've been trying to use
=offset(sav1!$F3,0,0,counta($F:$F),1) I've also tried the same but using
match(9999999,$F:$F) instead of count and still I am not getting the current
balance. Any help would be greatly appreciated.

Moving cell reference
 

hi
counta counts text
count counts numbers
try this.
=OFFSET(sav1!$F3,COUNTIF(sav1!$F:$F,"0")-1,0)

regards
FSt1

"David M" wrote:

I have 4 sheets each containing a running balance that as a transaction is
posted the balance moves to the next cell down. Example: balance is currently
in F4, I make a post that will change that balance and it will now be
displayed in F5.I want to have a summary sheet that will show the current
balance for all 4 accounts. Per some of the other posts regarding dynamic
ranges I've been trying to use
=offset(sav1!$F3,0,0,counta($F:$F),1) I've also tried the same but using
match(9999999,$F:$F) instead of count and still I am not getting the current
balance. Any help would be greatly appreciated.

Moving cell reference
 

Thank's to both of you. FST1, I made the change and it works fine. Also, Jim,
I found the article to be very helpful in understanding how all this works.
Thank's again to both of you.

"FSt1" wrote:

hi
counta counts text
count counts numbers
try this.
=OFFSET(sav1!$F3,COUNTIF(sav1!$F:$F,"0")-1,0)

regards
FSt1

"David M" wrote:

I have 4 sheets each containing a running balance that as a transaction is
posted the balance moves to the next cell down. Example: balance is currently
in F4, I make a post that will change that balance and it will now be
displayed in F5.I want to have a summary sheet that will show the current
balance for all 4 accounts. Per some of the other posts regarding dynamic
ranges I've been trying to use
=offset(sav1!$F3,0,0,counta($F:$F),1) I've also tried the same but using
match(9999999,$F:$F) instead of count and still I am not getting the current
balance. Any help would be greatly appreciated.