Excel: Last entry in a column

Posted February 15, 2009 - 2:25pm by doughnut

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.

‹ Flush DNS Cache Gradient highlights for Stacks ›