Hi Biff,

Thank you for this formula, but could you please explain it to me? What
does 100^10 mean?

"T. Valko" wrote:

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