You're welcome. Thanks for the feedback!

Biff

"Mari C" wrote in message
...
Thanks biff - after I limited the size of the column I was able to enter
it
in the bottom of the column
Mari

"Biff" wrote:

Hi!

First entry in A1.

Last entry in An

=A1-LOOKUP(9.99999999E+307,A:A)

Biff

"Mari C" <Mari wrote in message
...
Hi all - I need a formula so that I get the difference between the
first
entry and the last entry - an ongoing log. How do I do that

thanks

Mari