Function for identifying the last entry in a table

[TiChNi]

Certainly there is some function or combination of functions that
solves for identifying the last entry in a column. Any help would be
appreciated. Example below.

column a
row 1 aaa
row 2 bbb
row 3 ccc
row 4 ddd
row 5
row 6

I would like a function that would use the array A1:A6 to identify the
last entry, that being "ddd" which was found at A4.

thanks

 

[Dave Peterson]

One way:

=LOOKUP(2,1/(A1:A999<>""),A1:A999)
(Make that 999 big enough to extend past the last possible row--but don't use
the whole column.)

 

[Harlan Grove]

One way:

=LOOKUP(2,1/(A1:A999<>""),A1:A999)
(Make that 999 big enough to extend past the last possible row--but don't
use
the whole column.)

....

Actually, if col A contained only text strings, OP could use VLOOKUP.

=VLOOKUP(REPT("z",255),A:A,1)