You might also try:
=LOOKUP(2,1/($3:$3<""),$3:$3)

"George" wrote:

Gary''s Student wrote:
if you have a row of data , say row 3, with no included blanks, then the last
value in that row is:

=INDEX($3:$3,COUNTA($3:$3))


How are formulas that have no results treated.