2

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 ?

5

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
4

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

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

enter image description here

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

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.