Let's say I need to copy/paste A1 5,000 times down the column.
Is there a way to make C4 skip numbers? So for example, in cell A2, I need it to say =C8+5 and not =C5+5.作者: wilslm 时间: 2011-10-4 02:17
is there something in c5, 6, 7 that is unique enough to allow you to make an if statement to code around it?作者: jacksparrow 时间: 2011-10-4 02:19
No, the numbers aren't unique enough to do an if/then statement. They're all log returns of specific quarters.
Also, the example isn't actually what I'm doing. I just basically need to copy/paste formulas but I need it to jump by more or less than what it automatically does.
I know I can use VB code, I was just wondering if there's an easier way to do it.作者: random_walker47 时间: 2011-10-4 02:21
Does the info in column C have to stay there or can you parse and re-reference the selected data you want?作者: dirk01 时间: 2011-10-4 02:23
I don't see why I wouldn't be able to parse it.
I'll have to do this for more than one column though. It's not just columns A and C作者: transferpricing 时间: 2011-10-4 02:25
use the INDIRECT() function作者: ruchita 时间: 2011-10-4 02:27
yep indirect works
in this particular case A1 =INDIRECT("c"&(ROW()*4),TRUE)+5
