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
 
Back
Top