Excel auto fill by series based on another column

[ftater23]

I want my seq_no column (B) to auto fill by 10s but I need it restart the series when the number in column A changes.

[TABLE="width: 128"]
<tbody>[TR]
[TD]item_no[/TD]
[TD]seq_no[/TD]
[/TR]
[TR]
[TD]710000[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]710000[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]710001[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]710001[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]710001[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]710001[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]710002[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]710002[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]710002[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]710003[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]710003[/TD]
[TD]20[/TD]
[/TR]
</tbody><colgroup><col span="2"></colgroup>[/TABLE]

 

[hurgadion]

Hi,
try the formula:

=IF(OR(ROW()=2,A1<>A2),10,B1+10)

Best regards.

 

[T. Valko]

I want my seq_no column (B) to auto fill by 10s but I need it restart the series when the number in column A changes.

[TABLE="width: 128"]
<TBODY>[TR]
[TD]item_no
[/TD]
[TD]seq_no
[/TD]
[/TR]
[TR]
[TD]710000
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]710000
[/TD]
[TD]20
[/TD]
[/TR]
[TR]
[TD]710001
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]710001
[/TD]
[TD]20
[/TD]
[/TR]
[TR]
[TD]710001
[/TD]
[TD]30
[/TD]
[/TR]
[TR]
[TD]710001
[/TD]
[TD]40
[/TD]
[/TR]
[TR]
[TD]710002
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]710002
[/TD]
[TD]20
[/TD]
[/TR]
[TR]
[TD]710002
[/TD]
[TD]30
[/TD]
[/TR]
[TR]
[TD]710003
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]710003
[/TD]
[TD]20
[/TD]
[/TR]
</TBODY>[/TABLE]

Try this...

Sheet1

*	A	B

<COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 72px"><COL style="WIDTH: 72px"></COLGROUP><TBODY>
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: center"]710000[/TD]
[TD="align: center"]10[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: center"]710000[/TD]
[TD="align: center"]20[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: center"]710001[/TD]
[TD="align: center"]10[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: center"]710001[/TD]
[TD="align: center"]20[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: center"]710001[/TD]
[TD="align: center"]30[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: center"]710001[/TD]
[TD="align: center"]40[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: center"]710002[/TD]
[TD="align: center"]10[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: center"]710002[/TD]
[TD="align: center"]20[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="align: center"]710002[/TD]
[TD="align: center"]30[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]
[TD="align: center"]710003[/TD]
[TD="align: center"]10[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]
[TD="align: center"]710003[/TD]
[TD="align: center"]20[/TD]

</TBODY>

This formula entered in B2 and copied down:

=COUNTIF(A$2:A2,A2)*10

 

[ftater23]

Thank you!!!!