Get the Row Number After Minus 1 Row

[muhammad susanto]

hi all...

how to get the row number depend on data adjacent.
the row always minus 1 row
like that below :

Excel 2007

row	A	B
data

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]expected result after formula[/TD]

[TD="align: center"] 2 [/TD]
[TD="align: center"]5[/TD]
[TD="align: center"] 1 [/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"] 5 [/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"] 6 [/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"] 12 [/TD]

[TD="align: center"] 6 [/TD]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]

[TD="align: center"] 7 [/TD]
[TD="align: center"]10[/TD]
[TD="align: center"][/TD]

[TD="align: center"]8[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]

[TD="align: center"]10[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]

[TD="align: center"]11[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]

[TD="align: center"]12[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]

[TD="align: center"] 13 [/TD]
[TD="align: center"]24[/TD]
[TD="align: center"][/TD]

</tbody>

any help, much appreciated...

m.susanto

 

[Aladin Akyurek]

In B2 control+shift+enter, not just enter, and copy down:

=IFERROR(SMALL(IF(ISNUMBER(1/$A$2:$A$13),ROW($A$2:$A$13)-ROW($A$2)+1),ROWS($B$2:B2)),"")

 

[muhammad susanto]

In B2 control+shift+enter, not just enter, and copy down:

=IFERROR(SMALL(IF(ISNUMBER(1/$A$2:$A$13),ROW($A$2:$A$13)-ROW($A$2)+1),ROWS($B$2:B2)),"")

hello Aladin, wow.....Amazing, working well..

thank you so much..

 

[Aladin Akyurek]

hello Aladin, wow.....Amazing, working well..

thank you so much..

You are welcome.