Bob,

Try this

=INDEX(B:B,MAX(IF(B35:B39<"",ROW(35:39))))

it's an array formula, so commit with Ctrl-Shift-Enter

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"rleonard" wrote in message
...
My formula returns last value in column of numbers. If none of the cells
are blank between first entry and last entry,the
formula works. But if one cell is blank formula returns last entry before
blank cell. How can i modify formula to display
last entry even if their is a blank cell?
EXAMPLE:
b35 45
b36 50
b37 55
b38
b39

In above example formula returns 55 which is correct!

b35 45
b36
b37 55
b38
b39

In above example returns 45, I need it to return 55 as that is last entry!

Following is my formula:

=INDEX(B35:B39,COUNTA(B35:B39),1)

Thanks
Bob Leonard