Code:


Function stanje(cell As Range)
Do
If IsEmpty(cell.Offset(1, 0)) = False Then
cell = cell.Offset(1, 0)
End If
Loop Until IsEmpty(cell.Offset(1, 0)) = True
stanje = cell.Value
End Function

Code:

=INDEX(B1:B9,MAX(IF(LEN(B1:B9)>0,ROW(B1:B9),0)),1)

Code:

=INDIRECT(ADDRESS(MAX(IF(ISNUMBER(B1:B7),ROW(B1:B7),0)),COLUMN(B1:B7)))