maintaining pattern while dragging down the column in excel

[genetist]

hi to all
Good Evening

I have values 1, 2, 3 in column A and then i want to copy them in column B like
1
2
3
1
2
3
1
2
3
1
2
3

like this for number of times i want. I tried index, Mod and offset but no success, now i am doing manually but taking long time, is there any formula to do so? if any help in this regard will be highly appreciated
Thanks in advance
Regards,

 

[Norie]

You could try this in B1 and copy it down.

=INDEX($A$1:$A$3,MOD(ROW()-1,3)+1)

Note, if you want to copy the formula down multiple rows quickly you can enter the range you want to copy to, e.g. B1:B10000 in the name box, enter the formula in the address bar and press CTRL+ENTER.

 

[Scott T]

After you drag the fill handle down click on the auto fill options box and select copy cells.

 

[genetist]

Dear Norie and Scott T
thanks lot for your help and time spent to help your formula working perfectly as per my needs
once again thanks lot