Sample sheet here (in sheet3): https://docs.google.com/spreadsheets/d/1hXZzwRnYpso_Q4PHd6M818oE347yRBAh9AqTLhqX8TM/edit#gid=318977824
In part 3 of
Arrayformula Alternatives series of question, I still can't figure out a straightforward way of using arrayformula to do a "if condition(s) is true, previousrow++" or just a syntax to reference the previous row for calculating the current row.
As usual, design a
Arrayformula based solution that gives the same results as column B of sample sheet.