The easiest way is to use the
OFFSET function. The function prototype appears as follows:
=OFFSET(range, rows, columns, height, width)
To apply this for your situation, set
range to the first cell of data (use an ABSOLUTE reference, see below in the formulas),
rows to the offset,
columns to 0 (since we don't want to shift the column), and finally set
width to 1 (since we are returning a single cell).
So, assuming your data above is in column A, you can return the 4th, 8th, and 12th entry via the following formulas:
=OFFSET($A$1, 3, 0, 1, 1) or =OFFSET($A$1, 4 - 1, 0, 1, 1)
=OFFSET($A$1, 7, 0, 1, 1) or =OFFSET($A$1, 8 - 1, 0, 1, 1)
=OFFSET($A$1, 11, 0, 1, 1) or =OFFSET($A$1, 12 - 1, 0, 1, 1)
Note that you subtract 1 from each, since
rows is an OFFSET (so to get cell A4, you offset A1 by 3 rows, not 4). If you enter the first few cells manually, you can use Excel's auto-fill function to perform this automatically for the rest of the data.
You can also use the
INDIRECT formula to accomplish this. First, make a new column with the row numbers you want (e.g. 1, 5, 9...). Then, in the adjacent columns, put the formula
=INDIRECT("A" & REF) where
REF is the cell to the left (with the row number), and "A" is the column containing your data.
Obviously, you can do this for any arbitrary number set. So, if you enter the following into Excel:
A B C
1 D1 4 =INDIRECT("A" & B1)
2 D2 8 =INDIRECT("A" & B2)
3 D3 12 =INDIRECT("A" & B3)
You will see the contents
D12 in column C. You can use auto-fill to extend these formulas as far as you need.