I am trying to create a running column array that counts the number of occurrences by person by week. It can't be a pivot table or separate array table but a calculated column that updates beside the raw data. I think I need a combination of an array, vlookup, and query, but I am unsure how to do it.
Here is an example of the sheet: https://docs.google.com/spreadsheets/d/1KtFZX4K2LmPqgm1PDQ28i2GcbrVEr4TYwzKjbQiZs_U/edit?usp=sharing
I've tried this solution:
https://stackoverflow.com/questions/62814725/group-by-id-and-count-by-sub-unique-id-in-google-sheet-or-excel
Creating a WeekNumber
column and grouping the data that way. (The attempt is in the spreadsheet example).
Any thoughts on how to make this work?