Skipping Every 5th Row and Dragging Down To Get New Data

[seannydj]

Hey Guys,

I am the definition of a newbie and this is probably a dumb question. I am trying to make an Excel doc for my fantasy football team and I want help on how to make it a little easier. I would like to grab just the names and simply add a formula a column over and drag down to collect all the names (The names are all 5 rows below each other). Is there a formula that does that?

Did that even make sense?

All and any help will be appreciated. See the attached information to make it a bit more clear.

Excel Question.jpg.

[seannydj]

I believe I figured it out in case anyone cares:

=INDEX($A$2:$A$1000,5*(ROWS($A$3:A4)-1)+1)

Excel Answer.jpg

[Teethless mama]

In B2: =INDEX(A$2:A$100,ROWS($1:1)*5-4)

Adjust your range to suit.
copy down as far as needed.

[seannydj]

That was perfect! Thank you very much!

[Teethless mama]

You're Welcome!