Multiple Fill Series

[Alec Kolundzic]

Can anyone help;

I am looking for an Function that will automatically fill
a series in multiples of say 4 as follows:

A1=DI B1=0101
A2=DI B2=0102
A3=DI B3=0103
A4=DI B4=0104
A5=DI B5=0201
A6=DI B6=0202
A7=DI B7=0203
A8=DI B8=0204
A9=DO B9=0901
A10=D0 B10=0902
A11=DO B11=0903
A12=DI B12=0301
A13=DI B13=0302
A14=DO B14=0904

Any ideas
Thanks Alec

 

[Frank Kabel]

Hi alex
don't understand the logic behind column A and B11:B13. Seems you have
a dependency between col. a + B but you may explain the algorithm
you're trying to apply with some more detail