Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to do the following copying?
1 view
Skip to first unread message
cyberdude
May 24, 2012, 3:00:26 AM5/24/12
to
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
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
May 24, 2012, 3:42:27 AM5/24/12
to
=INDEX(A:A,2*ROWS($C$2:C2)-1)
0 new messages