In cell B1 copy the formula and copy that down... this will pick only the
values in A2,A4 ... Once done. copy ColB. Right Click. Paste Special and OK
there itself.

In cell B1 copy the formula and copy that down... this will pick only the
values in A2,A4 ... Once done. copy ColB. Right Click. Paste Special and OK
there itself.

Suppose the numbers are in range A2:A9. In cell A1, type Numbers. In cell
A12, use the following formula =MOD(ROW(A2:A9),2)=1. Now go to Data >
Filter > Advanced Filter and select "Copy to another location". In the list
range, refer to range A1:A9. In the criteria rang, refer to range A11A12
and in the copy to box , select D19. Now click on OK.

Please note that this is not a dynamic solution I.e.if any values change in
range A2:A9, the result in D19 will not change - you will have to rerun
the advanced filter.

Suppose the numbers are in range A2:A9. In cell A1, type Numbers. In cell
A12, use the following formula =MOD(ROW(A2:A9),2)=1. Now go to Data >
Filter > Advanced Filter and select "Copy to another location". In the list
range, refer to range A1:A9. In the criteria rang, refer to range A11A12
and in the copy to box , select D19. Now click on OK.

Please note that this is not a dynamic solution I.e.if any values change in
range A2:A9, the result in D19 will not change - you will have to rerun
the advanced filter.

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.