| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
