=INDEX(A1:A10,MAX(IF(A1:A10<"",ROW(A1:A10))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"OCONUS" wrote in message
...
I'm trying to create a fn that will give me the contents of the last cell
in
specific rows. The column of that cell differs by row, unfortunately, and
occasionally the content is '0', which I would need to have as a result of
the formula. Any assistance would be greatly appreciated. Thanks.