This time challenge is to write a formula which can be dragged down to generate number sequence 1,2,3,4,5 and repeats this sequence again. The formula should be flexible enough to be put in any cell and be dragged down. Hence, if I put the formula in D4, dragging down should produce the below series.
1
2
3
4
5
1
2
3
4
5
1
2
3
4
5
Note – If you wish, you may like to post your answer in the comments.