Can I do it without using macro?
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 |
Can I do it without using macro?
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 |
Can I do it without using macro?
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 |
All times are GMT +1. The time now is 06:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com