Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
Where are instructions for using Check Register template in Excel. | Excel Discussion (Misc queries) | |||
#REF! with cell value check | Excel Discussion (Misc queries) |