ScreamingMidget
New Member
- Joined
- Mar 11, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
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
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