Hi,

I want to do the following:

values of cells C20, C40, C60, C80, C100... are given,

then I need the value of A1 to be that of C20, value of A2 to be that
of C40, value of A3 to be that of C60 and so on.

Is there a quick way to do the above without writing a macro?

Thank you.

David

Put this in A1 and copy down

=INDEX(C:C,ROWS($A$1:A1)*20)

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"cyberdude" wrote in message
oups.com...
Hi,

I want to do the following:

values of cells C20, C40, C60, C80, C100... are given,

then I need the value of A1 to be that of C20, value of A2 to be that
of C40, value of A3 to be that of C60 and so on.

Is there a quick way to do the above without writing a macro?

Thank you.

David

cell a1 =indirect("a"&row()*20)
copy down as required.

"cyberdude" wrote:

Hi,

I want to do the following:

values of cells C20, C40, C60, C80, C100... are given,

then I need the value of A1 to be that of C20, value of A2 to be that
of C40, value of A3 to be that of C60 and so on.

Is there a quick way to do the above without writing a macro?

Thank you.

David