Last time, I posed a challenge to generate a repeating number sequence. This time, there is small twist. The sequence which you need to generate is 3 times each number i.e. 111222333444555………..
The formula should be flexible enough to be put in any cell and be dragged down. Hence, if I put the formula in C8, dragging down should produce the below series.1
1
1
2
2
2
3
3
3
4
4
4
Note – If you wish, you may like to post your answer in the comments.