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.
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
Thanks,
Eddie
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.
A | B | C |
Item | PSharing | SH# |
1 | AA2 | 1 |
2 | AA2 | 1 |
3 | AA3 | 2 |
4 | AA3 | 2 |
5 | AA3 | 2 |
6 | AA4 | 3 |
7 | AA4 | 3 |
8 | AA4 | 3 |
9 | AA4 | 3 |
10 | AA5 | 4 |
11 | AA5 | 4 |
12 | AA5 | 4 |
13 | AA5 | 4 |
14 | AA5 | 4 |
15 | AB2 | 5 |
16 | AB2 | 5 |
17 | AB3 | |
18 | AB3 | |
19 | AB3 | |
20 | AB4 | |
21 | AB4 | |
22 | AB4 | |
23 | AB4 | |
24 | AB5 | |
25 | AB5 | |
26 | AB5 | |
27 | AB5 | |
28 | AB5 | |
29 | AC2 | |
30 | AC2 | |
31 | AC3 | |
32 | AC3 | |
33 | AC3 | |
34 | AC4 | |
35 | AC4 | |
36 | AC4 | |
37 | AC4 | |
… |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
Thanks,
Eddie