Auto-populate sequence

[eddiegb1]

Hi,

Is there a way to automate the process below?

Auto-populate a column with a sequence number using another column as a lookup.

For example, in the data shown below, auto-populate column C (SH#) with a numeric value in a sequence using the contents in column B (PSharing).
And if the values in B are the same - the numeric value entered in column C will be the same/repeated.

Note:
Rows go up to 20000+. So doing this manually is time-consuming.

[TABLE="width: 164"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Item[/TD]
[TD]PSharing[/TD]
[TD]SH#[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]AA2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]AA2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]AA3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]AA3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]AA3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]AA4[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]AA4[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]AA4[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]AA4[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]AA5[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]AA5[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]AA5[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]AA5[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]AA5[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]AB2[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]AB2[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]AB3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]AB3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]AB3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]AB4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]AB4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]AB4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]AB4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]AB5[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]AB5[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]AB5[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]AB5[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]AB5[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]AC2[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]AC2[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]AC3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]AC3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]AC3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD]AC4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD]AC4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD]AC4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]37[/TD]
[TD]AC4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]…[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thanks,
Eddie

 

[Eric W]

Put this in C2 and drag down:

=IF(B2=B1,C1,SUM(C1,1))

 

[Peter_SSs]

In a similar vein, in C2 copied down

=N(C1)+(B2<>B1)

 

[eddiegb1]

Wow, that works! and so simple.

Thank you.

Eddie

 

[eddiegb1]

In a similar vein, in C2 copied down

=N(C1)+(B2<>B1)

Simple n Nice!

Thank you Peter - this works great too.

 

[Peter_SSs]

Thank you Peter - this works great too.

No problem. Just another option.