Excel: Last entry in a column

Sorting through some old emails, I found this tip that I'd saved from sometime ago.

To return the last entry in a specified column:

=LOOKUP(9.99999999999999E+307,D:D)

Discovered this little gem on this site.