Function for identifying the last entry in a table

  • Thread starter Thread starter TiChNi
  • Start date Start date
T

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
 
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.)
 
Dave Peterson said:
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.)
Click to expand...
....

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

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