Excel - How to do the following copying?

Asked By cyberdude on 24-May-12 03:00 AM
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


joeu2004 replied to cyberdude on 24-May-12 03:42 AM
Try a different approach.  Enter the following formula in C2 and copy down:

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