Below is the proposed solution for challenge – Challenge 10 – Generate a Repeating Number Sequence – I
Put following in a cell and drag down –
=MOD(ROWS($1:1)-1,5)+1
This will generate a sequence 1, 2, 3, 4, 5 and will repeat this.
Below is the proposed solution for challenge – Challenge 10 – Generate a Repeating Number Sequence – I
Put following in a cell and drag down –
=MOD(ROWS($1:1)-1,5)+1
This will generate a sequence 1, 2, 3, 4, 5 and will repeat this.
Nice solution, but if it's used in more than one column begging in different cells it does not work as expected.
Below a solutions correting this problem:
=IF(ROW()=1,1,MOD(INDIRECT(ADDRESS(ROW()-1,COLUMN() )),5) +1)