ExcelBanter - How do I create recurring entries in Excel?

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
---
"Seth" wrote:
I use Excel to manage a financial ledger. I want to create recurring monthly
entries. Is there a way to make this happen using an excel formula or macro?