Tinker around with this simple formulas play
for some ideas on what is possible
Assume you have 3 source items listed in A1:A3, eg:
Item1
Item2
Item3
A) Put this in any start cell, say in C2:
=INDEX($A$1:$A$3,INT((ROWS($1:1)-1)/2)+1,)
Copy C2 down to C7
You'd get this repeating structure which draws out the source list:
Item1
Item1
Item2
Item2
Item3
Item3
where the "2" within the INT part of it
sets how many times to repeat each source item in the source list
(If you change the "2" to "3" in C2, then copy down,
it'll triplicate list the source items in sequence)
B) Put this in D2:
=INDEX($A$1:$A$3,MOD(ROWS($1:1)-1,3)+1)
Copy D2 down to D7
You'd now get this kind of cyclic repeating structure on the source list:
Item1
Item2
Item3
Item1
Item2
Item3
where the "3" within the MOD part of it
is equal to the number of source items (in A1:A3)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
