Auto Fill Rules

[ronie85]

I am trying to set auto fill in Column L. L1 I have =f1, L2 I have =j1, L3 I have =f2, L4 I have =j2. I want this to continue down the L's but the auto fill wont work. I want it to progress =f1 =j1 =f2 =j2 =f3 =j3 =f4 =j4 and so on. Instead it is jumping cells. How do I fix this?

 

[shg]

[table="width:, class:grid"][tr][td] [/td][td]

f​

[/td][td]

j​

[/td][td]

l​

[/td][td]

m​

[/td][/tr]
[tr][td]

1​

[/td][td]a[/td][td]b[/td][td]a[/td][td]l1: =index(if(mod(rows(l$1:l1), 2),f:f,j:j ), int((rows(l$1:l1)-1)/2) + 1)[/td][/tr]

[tr][td]

2​

[/td][td]c[/td][td]d[/td][td]b[/td][td][/td][/tr]

[tr][td]

3​

[/td][td][/td][td][/td][td]c[/td][td][/td][/tr]

[tr][td]

4​

[/td][td][/td][td][/td][td]d[/td][td][/td][/tr]
[/table]

 

[ronie85]

thanks, that works, although it starts 4 rows down in L8 instead of L4.

 

[shg]

Pardon? L1? L4? L8??

Start again, and explain what you really want.

 

[ronie85]

Its fine, the formula works.

 

[shg]

Good job, you're welcome.