Copy values from nth row from column on other sheet

[BKGLTS]

Hello,

I have found a few different solutions online for this that seem quite simple but just won't work for me. I need help please.
I have a column (F) of values, text, and blanks on Sheet1 that I need to copy the values of every 5th row into a new list on Sheet2 starting with F3.

I have this on Sheet1 column F:

F1=Header
F2valuesr
F3=8
F4=(blank)
F5=Description
F6=(blank)
F7=(blank)
F8=16
F9=(blank)
F10=Description
F11=(blank)
F12=(blank)
F13=5
etc...

On Sheet2 I want this:
D2=8
D3=16
D4=5
etc...

Thank you!

 

[BKGLTS]

Please show us the formula. I do not like clicking on links.

Starting at 1

If you want to start copying at the first row, then follow the every nth pattern, you can adjust the formula like this:​

=OFFSET($B$5,(ROW(A1)-1)*n,0)

Starting at Nth

To copy values or generate references with a pattern like every 3rd row, every 7th line, etc. you can use a formula based on the the OFFSET and ROW functions. In the example shown, the formula in D5 is:​

=OFFSET($B$5,(ROW(D1)*3)-1,0)

 

[My Aswer Is This]

Thanks.

Starting at 1

If you want to start copying at the first row, then follow the every nth pattern, you can adjust the formula like this:​

=OFFSET($B$5,(ROW(A1)-1)*n,0)

Starting at Nth

To copy values or generate references with a pattern like every 3rd row, every 7th line, etc. you can use a formula based on the the OFFSET and ROW functions. In the example shown, the formula in D5 is:​

=OFFSET($B$5,(ROW(D1)*3)-1,0)

 

[Rick Rothstein]

What part of this formula specifies how many rows to skip before copying the next number? I need to be able to specify how many rows to skip please.

I commented about missing the skip rows requirement for my my macro
and then turned around and posted a formula that ignored the requirement.

 

[Rick Rothstein]

Starting at 1

If you want to start copying at the first row, then follow the every nth pattern, you can adjust the formula like this:​

=OFFSET($B$5,(ROW(A1)-1)*n,0)

Starting at Nth

To copy values or generate references with a pattern like every 3rd row, every 7th line, etc. you can use a formula based on the the OFFSET and ROW functions. In the example shown, the formula in D5 is:​

=OFFSET($B$5,(ROW(D1)*3)-1,0)

OFFSET is a Volatile function... you can make your formulas non-Volatile by using the INDEX function instead...

Starting at 1: =INDEX(B:B,ROWS($1:1)*n)

Starting at Nth: =INDEX(B:B,ROWS($1:1)*n+n-1)

Note: I changed the Row(A1) from your posted formula to ROWS($1:1) as it should be better at protecting the formula's cell references against deleting (or inserting) of rows should you ever need to do that in the future.