View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Check Register Balance

Assuming column G is the balance column:

=LOOKUP(100^10,G:G)

Will return the last numeric value from column G.

Biff

"Janet" wrote in message
...
How do I show a check register balance which changes with each entry in a
designated single cell so I can easily link it to another document?
--
Janet