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:

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

A​

[/td][td]

B​

[/td][td]

C​

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

1​

[/td][td]$A$1[/td][td]$A$1[/td][td]

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

[/td][/tr]

[tr][td]

119​

[/td][td]$A$119[/td][td]$A$10[/td][td][/td][/tr]

[tr][td]

237​

[/td][td]$A$237[/td][td]$A$19[/td][td][/td][/tr]

[tr][td]

355​

[/td][td]$A$355[/td][td]$A$28[/td][td][/td][/tr]
[/table]

 

[samweise]

Sure it does:

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]$A$1[/TD]
[TD]$A$1[/TD]
[TD]

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

[/TD]
[/TR]
[TR]
[TD]

119​

[/TD]
[TD]$A$119[/TD]
[TD]$A$10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

237​

[/TD]
[TD]$A$237[/TD]
[TD]$A$19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

355​

[/TD]
[TD]$A$355[/TD]
[TD]$A$28[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

You're right! Thanks a lot!

 

[shg]

You're welcome.