it's not the cleanest way to do it, but the only way i know
how to do this is if you know what the maximum number of
rows you have is. try this:

= Range("B50").End(xlUP).Value

where the "B50" cell is further down than the rows you
have. how this works is that you give it a cell to start at
and excel works its way up the culumn from the bottom cell
you provide until it finds the first non-empty cell. hope
that helps


-----Original 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

.