Reference in every nth cell

[qasimmalik]

Hi guys,

I need to figure out a way to enter a cell reference in every nth cell. Is there a macro or cell reference function I could use for this?

Example: cell AA is referenced in cell BB, cell AB is referenced in cell B4, cell AC is referenced in B6.... and so on. I want to reference the cells in column A to every 2nd cell in column B.

ABC
SHD	ABC
KDS
ADD	SHD
BBS
	KDS
	ADD
	BBS

<tbody>
</tbody>

Thank you in advance for the help.

 

[StephenCrump]

B2: =IFERROR(IF(MOD(ROWS(B$2:B2),N)=1,INDEX(A$1:A$5,1+(ROWS(B$2:B2)-1)/N),""),"")

where N is your required spacing, e.g. 2.

Book1
	A	B
1	ABC
2	SHD	ABC
3	KDS
4	ADD	SHD
5	BBS
6		KDS
7
8		ADD
9
10		BBS
Sheet1