Pulling data from every other row?

  • Thread starter Thread starter kval2227
  • Start date Start date
K

kval2227

I need to pull data for several hundred rows from every other line so it
should look like:

A2: =dataD2
A3: =dataD4
A4: =dataD6

I assumed I could highlight those first couple rows and drag down but that
doesn't work. Is there any way to do this?

Thanks
 
Put this in A2:

=INDEX(data!D:D,ROW(A1)*2)

then copy down as required.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort by Every Other Row? 0
Move data from every other row to columns 0
Consecutive cells pulling data from non-consective cells 2
Filtering of data in a master excel sheet from multiple sheets 3
Text to rows 4
Selecting every 4th row 3
Changing relative cell reference 2
Pull info from multiple worksheets into one Master 2

Back
Top