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
|