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
002. Four rows later, there are more type A's, and their counters increment to
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
How can I generate the values in column B?