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:
WeekNumber column and grouping the data that way. (The attempt is in the spreadsheet example).
Any thoughts on how to make this work?