Hi All
I have a spreadsheet with Activity IDs and with each activity there could be 1 or more associated Actions. I would like a formula to generate in column B which generates Unique Action IDs based on the Activity ID, as shown below. So that the first action for a given ID ends in "a", the second in "b" and onwards through the alphabet then to "aa", "ab", "ac" etc. Can someone help me with a formula for B2:B10 (onwards) please?
I have a spreadsheet with Activity IDs and with each activity there could be 1 or more associated Actions. I would like a formula to generate in column B which generates Unique Action IDs based on the Activity ID, as shown below. So that the first action for a given ID ends in "a", the second in "b" and onwards through the alphabet then to "aa", "ab", "ac" etc. Can someone help me with a formula for B2:B10 (onwards) please?
Book3 | ||||
---|---|---|---|---|
A | B | |||
1 | Activity ID | Action ID | ||
2 | ACT000001 | ACT000001a | ||
3 | ACT000002 | ACT000002a | ||
4 | ACT000003 | ACT000003a | ||
5 | ACT000001 | ACT000001b | ||
6 | ACT000049 | ACT000049a | ||
7 | ACT000021 | ACT000021a | ||
8 | ACT000021 | ACT000021b | ||
9 | ACT000021 | ACT000021c | ||
10 | ACT000021 | ACT000021d | ||
Sheet1 |