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