I have a data encoding project.
I will input my data in column A (equipment type), and the formulated cell would be in column B. Column B contains a string that starts with the value in column A, and appends an equipment-specific counter to it.
The different equipment types in column A can be in any order. The counter needs to increment within equipment type.
Whenever I input new data in a row in column A, the column B value would be automatically created, incrementing the counter by 1 for that equipment type.
In the example, the list starts with two type A's, whose counters are 001
and 002
. Four rows later, there are more type A's, and their counters increment to 003
and 004
.
In between, in rows 3, 4, and 5, there are types B, D, and C. Each of those has a counter starting at 001
. Farther down, there are second types D and C, and the counter on each is incremented by 1. Then a second and third type B, and those counters are incremented to 002
and 003
.
How can I generate the values in column B?