Dear Forum,
i'm trying to create a column that calculates an ID for a row based on the category where a row is assigned. The ID which is a numerical value (increasing integer) is calculated for a new row of a specific category on the basis of the IDs already used for the other rows of this category.
So the input for the formula would be column "category" (with eg. "a", "b" or "c") and maximum value of column ID in the rows where category corresponds to the category of the new row.
Please compare the following example:
<style type="text/css">.tg {border-collapse:collapse;border-spacing:0;} .tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;} .tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;} .tg .tg-e3zv{font-weight:bold} </style>
| Row number | Category | ID |
|---|---|---|
| 1 | a | 1 |
| 2 | b | 1 |
| 3 | b | 2 |
| 4 | c | 1 |
| 5 | a | 2 |
| 6 | b | 3 |
In the above example the next IDs per category would be a - 3, b - 4 and c - 2 and so on.
I hope that the description is quite clear and i'm looking forward to your feedback how this could be implemented.
Thank you and kind regards
Philipp
Other recent topics
