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]

	f​	j​	l​	m​
1​	a	b	a	l1: =index(if(mod(rows(l$1:l1), 2),f:f,j:j ), int((rows(l$1:l1)-1)/2) + 1)
2​	c	d	b
3​			c
4​			d

 

[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.