(RANKEQ) Derivative Numbering System e.g. 1a, 1b, 2a, 2b, 2c etc.
Hello, I’m a bit stuck with creating a numbering system – can anyone help please?
I have a list of IDs, but some of these IDs I want to mark as derivatives of others and automatically label the derivatives with a letter ideally – but a number will do.
I need my formula to look down a column, count distinct numbers and where [Derivative?] is True assign a rank within that range of distinct numbers.
So the first item in that ‘group’ of distinct numbers that is checked True will be 1 (or a), the second in that group would be 2 (or b) and so on. From there I can relate the number to a letter and concatenate the results to give me my output Item ID.
I have another row ID column that is autonumbered that could drive the ranking.
Or am I overthinking this?
Hope someone can help.
Help Article Resources
Check out the Formula Handbook template!