how : check register running balance is a stationary cell
 

the template for a check register has a running balance.... fine... i also
need the balance to read in a staionary cell at the top of the page so i
don't have to scroll down to get the balance....HELP

Hi Michele

this solution was posted by harlan grove to a similar question asked
recently

=LOOKUP(2,1/(-E1:E10<0),E1:E10)

where E1:E10 is the range you've interested in, change as necessary

Regards
JulieD

"Michele" wrote in message
...
the template for a check register has a running balance.... fine... i also
need the balance to read in a staionary cell at the top of the page so i
don't have to scroll down to get the balance....HELP

In the cell at the top put

=cell_with_running_balance

i.e. if the cell with the running balance is H45 then use

=H45


Regards,

Peo Sjoblom

"Michele" wrote:

the template for a check register has a running balance.... fine... i also
need the balance to read in a staionary cell at the top of the page so i
don't have to scroll down to get the balance....HELP

i guess i didn't explain clearly.....try this link to see the register
http://office.microsoft.com/en-us/te...1033..... the
balance changes cell after every entry....i need that plus a stationary cell
with the balance.....how do i grab the new balance every time i changes


"Peo Sjoblom" wrote:

In the cell at the top put

=cell_with_running_balance

i.e. if the cell with the running balance is H45 then use

=H45


Regards,

Peo Sjoblom

"Michele" wrote:

the template for a check register has a running balance.... fine... i also
need the balance to read in a staionary cell at the top of the page so i
don't have to scroll down to get the balance....HELP

Hi Michele

did you try my solution? ... looking at the link you just need to change the
E to G and increase the 10 to last possible row you could use.

Cheers
JulieD

"Michele" wrote in message
...
i guess i didn't explain clearly.....try this link to see the register
http://office.microsoft.com/en-us/te...1033..... the
balance changes cell after every entry....i need that plus a stationary
cell
with the balance.....how do i grab the new balance every time i changes


"Peo Sjoblom" wrote:

In the cell at the top put

=cell_with_running_balance

i.e. if the cell with the running balance is H45 then use

=H45


Regards,

Peo Sjoblom

"Michele" wrote:

the template for a check register has a running balance.... fine... i
also
need the balance to read in a staionary cell at the top of the page so
i
don't have to scroll down to get the balance....HELP

thank you......that works good except for when i manipulat the total to come
to $0 the the formula doesn't seem to know how to read that?????

"JulieD" wrote:

Hi Michele

this solution was posted by harlan grove to a similar question asked
recently

=LOOKUP(2,1/(-E1:E10<0),E1:E10)

where E1:E10 is the range you've interested in, change as necessary

Regards
JulieD

"Michele" wrote in message
...
the template for a check register has a running balance.... fine... i also
need the balance to read in a staionary cell at the top of the page so i
don't have to scroll down to get the balance....HELP

Hi Michele

sorry, that formula looks for the last non-zero value ... use this one
instead
=INDEX(E1:E10,MATCH(9.99999999999999E+307,E1:E10))

Cheers
JulieD

"Michele" wrote in message
...
thank you......that works good except for when i manipulat the total to
come
to $0 the the formula doesn't seem to know how to read that?????

"JulieD" wrote:

Hi Michele

this solution was posted by harlan grove to a similar question asked
recently

=LOOKUP(2,1/(-E1:E10<0),E1:E10)

where E1:E10 is the range you've interested in, change as necessary

Regards
JulieD

"Michele" wrote in message
...
the template for a check register has a running balance.... fine... i
also
need the balance to read in a staionary cell at the top of the page so
i
don't have to scroll down to get the balance....HELP

working now.......thank you so much......sorry to have been a pain


"JulieD" wrote:

Hi Michele

sorry, that formula looks for the last non-zero value ... use this one
instead
=INDEX(E1:E10,MATCH(9.99999999999999E+307,E1:E10))

Cheers
JulieD

"Michele" wrote in message
...
thank you......that works good except for when i manipulat the total to
come
to $0 the the formula doesn't seem to know how to read that?????

"JulieD" wrote:

Hi Michele

this solution was posted by harlan grove to a similar question asked
recently

=LOOKUP(2,1/(-E1:E10<0),E1:E10)

where E1:E10 is the range you've interested in, change as necessary

Regards
JulieD

"Michele" wrote in message
...
the template for a check register has a running balance.... fine... i
also
need the balance to read in a staionary cell at the top of the page so
i
don't have to scroll down to get the balance....HELP

Hi Michele

glad it's solved and you certainly weren't a pain - it would have been
sensible of me to include both formula in my inital post.

Cheers
JulieD

"Michele" wrote in message
...
working now.......thank you so much......sorry to have been a pain


"JulieD" wrote:

Hi Michele

sorry, that formula looks for the last non-zero value ... use this one
instead
=INDEX(E1:E10,MATCH(9.99999999999999E+307,E1:E10))

Cheers
JulieD

"Michele" wrote in message
...
thank you......that works good except for when i manipulat the total to
come
to $0 the the formula doesn't seem to know how to read that?????

"JulieD" wrote:

Hi Michele

this solution was posted by harlan grove to a similar question asked
recently

=LOOKUP(2,1/(-E1:E10<0),E1:E10)

where E1:E10 is the range you've interested in, change as necessary

Regards
JulieD

"Michele" wrote in message
...
the template for a check register has a running balance.... fine...
i
also
need the balance to read in a staionary cell at the top of the page
so
i
don't have to scroll down to get the balance....HELP

once again.........THANK YOU

"JulieD" wrote:

Hi Michele

glad it's solved and you certainly weren't a pain - it would have been
sensible of me to include both formula in my inital post.

Cheers
JulieD

"Michele" wrote in message
...
working now.......thank you so much......sorry to have been a pain


"JulieD" wrote:

Hi Michele

sorry, that formula looks for the last non-zero value ... use this one
instead
=INDEX(E1:E10,MATCH(9.99999999999999E+307,E1:E10))

Cheers
JulieD

"Michele" wrote in message
...
thank you......that works good except for when i manipulat the total to
come
to $0 the the formula doesn't seem to know how to read that?????

"JulieD" wrote:

Hi Michele

this solution was posted by harlan grove to a similar question asked
recently

=LOOKUP(2,1/(-E1:E10<0),E1:E10)

where E1:E10 is the range you've interested in, change as necessary

Regards
JulieD

"Michele" wrote in message
...
the template for a check register has a running balance.... fine...
i
also
need the balance to read in a staionary cell at the top of the page
so
i
don't have to scroll down to get the balance....HELP