Have every nth cell in a column refer to every rth in a different sheet?

[samweise]

Hi All,

I am trying to have every 118th cell in a column of one sheet refer to every 9th cell of a column in another sheet. Any way to do this?

Thanks,
Sam

 

[shg]

Entered in row 1, this refers to Sheet1!A1:

=INDEX(Sheet1!$A:$A, INT(9/118*(ROW()-1) + 1)

Entered in row 119, it refers to Sheet1!A2.

 

[samweise]

Entered in row 1, this refers to Sheet1!A1:

=INDEX(Sheet1!$A:$A, INT(9/118*(ROW()-1) + 1)

Entered in row 119, it refers to Sheet1!A2.

Thanks! This works for the first and 118th rows, but after that it doesn't seem to work. Any advice?

 

[shg]

Sure it does:

	A​	B​	C​
1​	$A$1	$A$1	B1: =INDEX(Sheet1!$A:$A,INT(9/118*(ROW()-1)+1))​
119​	$A$119	$A$10
237​	$A$237	$A$19
355​	$A$355	$A$28

 

[samweise]

Sure it does:

	A​	B​	C​
1​	$A$1	$A$1	B1: =INDEX(Sheet1!$A:$A,INT(9/118*(ROW()-1)+1))​
119​	$A$119	$A$10
237​	$A$237	$A$19
355​	$A$355	$A$28

<tbody>
</tbody>

You're right! Thanks a lot!

 

[shg]

You're welcome.