I have a table as below:
I want to populate the
Aggregate column by doing a cumulative sum based on
Code column. Some of the rows have duplicated values, like row 2 and row 4, row 3 and row 5 etc. So that I can show that ID 1 has 2 unique codes, ID 2 has 3 unique codes etc.
I have tried this formula but it doesn't yield what I want.
My desired output is as below: