Below is a proposed solution for challenge – Challenge 11 – Generate a Repeating Number Sequence – II
Put following formula and drag down –
=ROUNDUP(ROWS($1:1)/3,0)
This will repeat the sequence 111222333444555………..
Below is a proposed solution for challenge – Challenge 11 – Generate a Repeating Number Sequence – II
Put following formula and drag down –
=ROUNDUP(ROWS($1:1)/3,0)
This will repeat the sequence 111222333444555………..