I'm totally stucked here and hope you can help me.
I need to generate non repeating groups shown in column group (table below).
The challenge is: Whenever state (compare table below) changes, the value in group must be increased by +1. If there is no change to the previous row, the group no. must remain the same. Any idea how to archive this?
I tried to archive this changes using functions like previous(), peek() and autonumber(), but unfortunately I don't get the desired result.
Loops did return the expected result, but I get unacceptable Performance issues (only 10 rows per second).