[Excel] Trazenje poslednje vrednosti u nizu - resenjahttp://www.elitesecurity.org/t203519-Excel-uporedjivanje
http://www.elitesecurity.org/t247644-0#1490532
http://www.elitesecurity.org/t...nalazenje-brojcane-vrijednosti
a resenja su:
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
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)
=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)))
=INDIRECT(ADDRESS(MAX(IF(ISNUMBER(B1:B7),ROW(B1:B7),0)),COLUMN(B1:B7)))
