Sub Nblign()
Dim Tablo, k As Long, Rlt(), x As Long
Tablo = Range("A1:B" & Range("A65536").End(xlUp).Row).Value
For k = 1 To UBound(Tablo, 1)
If Tablo(k, 2) = "Result" Then
ReDim Preserve Rlt(x)
Rlt(x) = k
x = x + 1
End If
Next
For k = 0 To UBound(Rlt)
If k <> UBound(Rlt) Then Cells(Rlt(k), 3) = (Rlt(k + 1) - Rlt(k)) - 1
Next
End Sub