Alternate cells so it's A-B-A-A-B-A-B-A-A-B...

[ScreamingMidget]

Ok, so currently I have content in Column A and Column B.

In Column D the contents of Col A and Col B are alternated as A-A-B ... A-A-B ... etc.

This is the formular I have so far for the original alternating:
=@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))

I'm wanting changes so that it's displayed instead as A-A-B-A-B... A-A-B-A-B etc. So B is displayed more often.

Any idea what I'd need to change to the formula?

Col A: Red, Blue, Yellow, Pink
Col B: 1, 2, 3, 4, 5

At the moment Col D goes: Red, Blue, 1, Yellow Pink, 2

I want it to so it's Red, Blue, 1, Yellow, 2. Pink, 3

 

[JamesCanale]

IF(MOD(ROWS(D$2:D2),3)<>0
becomes
IF(MOD(MOD(ROWS(D$2:D2),5),3)<>0

I'm not sure about the rest of it. If you posted a minisheet, I'd be able to make more sense of it.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Alternate data in columns A and B and input to Column D
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.