I have the following formulas on the third sheet of my workbook. They are simply cell references to the first sheet; on my 'output' page, I want to display every 17th cell of the 'input' sheet. However when I drag the formula down, it goes up in 2's. Any help gratefully appreciated.
=Input!B2 =Input!F10 =Input!F6 =Input!H11 =Input!F4 =Input!F13 =Input!F8
=Input!B19 =Input!F27 =Input!F23 =Input!H28 =Input!F21 =Input!F30 =Input!F25
(The use case is that I have "records" on the 'Input' sheet that are 17 rows high,
and I want to display summary data on the 'Output' sheet in a one-row-per-record arrangement.)
Best Answer
This formula will return A17. When draged down it will return the values in A34, A51, A68, etc. i.e. every 17th row.
If you want to start in a different row, say row 10, you need to subtract the respective number from the starting row, like 7.