| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling data from every other row?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pulling data from every other row?
Put this in A2:
=INDEX(data!D:D,ROW(A1)*2) then copy down as required. Hope this helps. Pete On Jan 18, 10:04*pm, kval2227 wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling data from other wb based on data to populate dropdown list | Excel Discussion (Misc queries) | |||
| Tying to extract all data from a pivot pulling from external data | Excel Discussion (Misc queries) | |||
| Linking two spreadsheet, pulling data from one cell to another, data is being truncated | Excel Worksheet Functions | |||
| pulling data from one sheet and listing selected data in another | Excel Worksheet Functions | |||
| Pulling data from web | Excel Discussion (Misc queries) | |||
Linear Mode
