Cell references in formulas

[iowaturf]

Hi,

Here is my problem:

I have a spreadsheet that has about 14,000 rows in it, and I need th
data from one cell out of every 27th row. For example, I need t
collect the values from D17, D44, D71, ... to D13814. I would lik
the values to be located in separate worksheet in consecutive cells:
B1, B2, B3, B4, etc.

Thank you for your help!!

Jaso

 

[JE McGimpsey]

One way:

B1: =INDEX(Sheet1!D,(ROW()-1)*27+17)

Copy down as far as required.