Odd instance of "fill-right" - skipping cells

[Berrett]

I have a data entry sheet. Data in column A is "words read", in column "B" is "words correct", and in column C there is a calculation that yields "accuracy".

On another sheet I want to see only the "words read" data lined up right next to each other. So on this second sheet A2 might have the formula:

='data entry'!A51

Then B2 would have the formula:

='data entry'!D51

I can't fill this formula to the right because the formula skips two columns. Is there a way to work around this? I don't want to write this formula 100 times. Thanks.

 

[Jonmo1]

Try

=INDEX('data entry'!51:51,(COLUMNS($A1:A1)-1)*3+1)

3 = Interval (every 3 columns)
1 = Column # to begin with (A=1, B=2,etc)

Do not change COLUMNS($A1:A1), it has nothing to do with your data.

Hope that helps.

 

[Berrett]

I don't think I fully understand why that works, but it does! Thanks a lot for your help.