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