How to do the following copying?
 

Hi,

I have a spreadsheet in which

cell C2 contains =A1,
cell C3 contains =A3,
cell C4 contains =A5

may I know what operation I can do, without using macro, such that
cell C5 contains =A7, cell C6 contains =A9, cell c7 contains =A11
etc? Thank you.

Mike

How to do the following copying?
 

"cyberdude" wrote:
I have a spreadsheet in which
cell C2 contains =A1,
cell C3 contains =A3,
cell C4 contains =A5
may I know what operation I can do, without using
macro, such that cell C5 contains =A7, cell C6
contains =A9, cell c7 contains =A11 etc?

Try a different approach. Enter the following formula in C2 and copy down:

=INDEX(A:A,2*ROWS($C$2:C2)-1)