How to number rows, skip blanks and then ...

[pingvin]

Hi,

I have a small problem. I have 3 colums A, B and C.
In col A I have Family serial number. All parts in the same family have the same serial number.
In col B I have sub serial numbers. Each sub part has it's own designated serial number.
In col C I would like Excel to number each row/sub part in the same family. However blank cells should be skipped.

[TABLE="class: grid, width: 500"]
<colgroup><col style="width:54pt" span="3" width="72"> </colgroup><tbody>[TR]
[TD="width: 72"]Col A
[/TD]
[TD="width: 72"]Col B[/TD]
[TD="width: 72"]Col C[/TD]
[/TR]
[TR]
[TD="align: right"]5555
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5555
[/TD]
[TD="align: right"]321
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD="align: right"]5555
[/TD]
[TD="align: right"]325[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]5555
[/TD]
[TD="align: right"]549[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]8888[/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD="align: right"]8888[/TD]
[TD="align: right"]649[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD="align: right"]8888[/TD]
[TD="align: right"]821
[/TD]
[TD="align: right"]2
[/TD]
[/TR]
[TR]
[TD="align: right"]2222[/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD="align: right"]2222[/TD]
[TD="align: right"]183[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]2222[/TD]
[TD="align: right"]243[/TD]
[TD="align: right"]2
[/TD]
[/TR]
[TR]
[TD="align: right"]2222[/TD]
[TD="align: right"]764[/TD]
[TD="align: right"]3
[/TD]
[/TR]
</tbody>[/TABLE]

I have tried this formula IF(A2=A1,C1+1) But the problem is that it doesn't skip blank cells, so it ends up numbering blank cells or generating "FALSE".
I have also tried IF(AND(B1>0,A2=A1),C1+1,"") but neither of the formula does what I would like to.
Can anybody help me with this problem.

 

[steve the fish]

This requires your data starting in row 2, ie the first 5555 in A2, and the data is sorted like in the example. In C2 place this:

=IF(A2=A1,(B2<>"")+IF(ISNUMBER(C1),C1,0),"")

 

[admiral100]

Hi,

Another option :-

C2 =IF(B2="","",N(C1)+1)

 

[pingvin]

Thank you for the help!