Pulling data from every other row?

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
 
P

Pete_UK

Put this in A2:

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

then copy down as required.

Hope this helps.

Pete
 
Top