'Repeat dynamic pattern in column after amount is greater than X
I am trying to create a savings spreadsheet where people save X amount of days in a week after they have reached X amount in income.
Can any Google Sheet experts help me achieve the following:
When the "amount" >= "min amount" (C1) then repeat the number of No's and Yes's according to the pattern (number of consecutive days) in B2 and B3
Example image:
Example Google Sheet:
https://docs.google.com/spreadsheets/d/1n4Jg_uZUHBKi36S7HnkWWqqBTSTo3nKY9QgWP7wK9_o/edit?usp=sharing
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
