Repeating Sequence of Numbers

Good day, how can I implement the repeating number sequence: 1,1,2,2,1,1,2,2,1,1... and etc.
Searched through entire internet but could not find any solution.
Thanks.

How about in B2 dragged down

Formula:

=MOD(INT((ROWS(B$2:B2)-1)/2),2)+1

I just saw Fluff's formula... use it (it is better than what I had posted).

Here is another approach you can consider (but Fluff's formula is still probably better)...

=0+MID("1122",1+MOD(ROWS($1:1)-1,4),1)

Glad to help & thanks for the feedback.

Originally Posted by Rick Rothstein

If you want brief and neat, try it this way. Manually put a 1 in cells A1 and A2, then put this formula in cell A3 and copy it down...

It would make sense if I just need a sequence itself. But I need this as a column parameter for INDEX to extract some data.

I may be missing something, but in what way does what I proposed not work?

It definitely work! But I needed solution in ONE formula without additional manual operations, like this:

Manually put a 1 in cells A1 and A2

Thanks.

I guess I am missing the problem. To use the ONE formula, you would have to manually put it in a cell and then copy down. The only difference with my solution is before you manually put the formula in a cell, you simply have to manually enter 1 twice. Once you have done that, no further attention is needed. And the formula I proposed is more efficient as there are no function calls for Excel to have to evaluate. Anyway, you have a solution you are happy with and that is all that matters in the end.

Attaching small example demonstrating the work of complete formula. Hope it will make things clear.

ANS. post#13

cell D2 formula , Drag down and across

HTML Code: 

Nice option via OFFSET, thank you!

@Strogg You're Welcome. Glad to help . Thank You for the feedback