I want to ask about numbering that repeats itself with the same conditions based on Column B and is limited to only 1 and 2 then returns to 1 so on.
as an example :
| Column A | Column B |
|---|---|
| 1 | John |
| 1 | John |
| 1 | John |
| 2 | Alpha |
| 2 | Alpha |
| 1 | Thomas |
| 1 | Thomas |
| 1 | Thomas |
| 2 | Charlie |
| 2 | Charlie |
| 1 | Tony |
| 2 | Thomas |
| 1 | Delta |
New contributor
Novas Wahyu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.