Alternate data in columns A and B (AAAB, AAAB repeat)

I have data in Column A (A2 down) and data in Column B (B2 down) and I want Column D to display in this order: AAAB, AAAB, repeat.

I currently have Column D going down, showing AAB, AAB, with this formula:

=@INDEX($A$2:$B$3000,IF(MOD(ROWS(D$2:D2),3)<>0,ROWS($D$2:$D2)-INT(ROWS($D$2:$D2)/3)*1,INT(ROWS($D$2:$D2)/3)),1+(MOD(ROWS($D$2:$D2),3)=0))

What do I change in the above, so that it displays 3 A's instead of 2?

I have almost 3000 rows, so I need to be able to simply copy D2 and paste down.

Originally Posted by Glenn Kennedy

I do not understand you. Please post a small sample Excel file, showing expected results.

Please see attached sheet.

Originally Posted by HansDouwe

One way (your way): Please replace the 3's in your formula by 4's:

Formula:

Please Login or Register  to view this content.

Thanks buddy, that seems to work!

I did the same thoing with two helper columns
One for mod and one flag. Have attached the snip-it

=INDEX($D$5:$E$11,IF(G11=0,MATCH(COUNTIFS(OFFSET($G$5,0,0,C11,1),0),$C$5:$C$11,0),MATCH(COUNTIFS(OFFSET($G$5,0,0,C11,1),1),$C$5:$C$11,0)),IF(G11=0,1,2))