# Copy every other value from a column

I have the below sample data set with values in `Column B` .

In `Column D` I want every other value, starting at `Row 1`.

``````0   A   B   C   D   F   G   H   I   J
1       20     =B1
2       10     =B3
3       30     =B5
4       8      =B7
5       9      =B9
6       4      etc.
7       79
8       67
9       63
10      45
``````

How can I do this with fill handle or a Formula ?

You need to use a formula:

`=INDIRECT("B"&INT(ROW()*2)-1)`

• It should be `(ROW()*2)-1)` – PeterH Aug 1 '18 at 12:33

In Cell D2 you can use the below formula, then drag down:

``````=INDEX(B:B,(ROWS(\$B\$1:B1)*2)-1,1)
``````

Edited:

Write this formula in Cell `D1` & fill down:

``````=INDEX(B:B,1+(2*ROW()-2))
``````

Note,

• If you want even row sequence like `10, 8, 4, 67` then write following formulain `D1` & fill down.

`=INDEX(B:B,1+(2*ROW()-1))`

• Adjust cell references in formula as needed.

• Please see the example data and provide a solution implementing that. – Máté Juhász Aug 1 '18 at 15:35
• Thanks @MátéJuhász, I got confused that OP is looking for Value from ODD & EVEN rows only so that ignored the Blanks, now edited the answer & values are in sequence. – Rajesh S Aug 2 '18 at 6:59