I have 4 columns: Name, Week, Batch and Units Produced (Cols, A,b,c,d). In column e, I need to keep running totals based on name and week. When the week changes for the same person, restart the total.
Fred, 12, 4001, 129.0 Answer in e: 129.0
Fred, 12, 4012, 234.0 Answer in e: 363.0
Fred, 13, 4023, 12.0 Answer in e:
…