Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
Pokepikachu
Posted - 08/15/2011 : 3:46:06 PM Origin Ver. 8 and Service Release (Select Help-->About Origin): Operating System: Windows 7 32 Bit
Hi all.
I got a work sheet with a row of data. Those row got 2000 entries. I like to copy the entries from 1 to 1000 into a second row and the data from 1001 to 2000 into another row (3rd row).
When I try col(b)=col(a)[1] The complete 2 row is filled with the first entry of the row. So I tried col(b)=col(a)[1:1000], but it doesnt work. There are only empry entries. So what solution would be suitable for me.
Thank you for help and answers :)
1 L A T E S T R E P L I E S (Newest First)
Hideo Fujii
Posted - 08/15/2011 : 4:14:00 PM Hi Pokepikachu,
Full notation of range is not supported in the formula. You need to have a range declaration to make a well-defined formula. Therefore, you can use: