hello,
i have the first 3 columns as below where i have a number for each product but i need to create the number based on which group it is in like in the 'new number' column.
Product | group | number | New number |
23243 | a | 1 | 1 |
23244 | a | 2 | 2 |
23245 | a | 3 | 3 |
23246 | a | 4 | 4 |
23247 | b | 5 | 1 |
23248 | b | 6 | 2 |
Solved! Go to Solution.
Thank you, it was very helpful :)