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
Aidyle
Posted - 11/01/2006 : 11:28:32 AM Origin Version (Select Help-->About Origin): Student Version 7.5 Operating System: XP
Hi, How do I subtract two rows from each other, and if so, where can the the output be. Also, is there a way that I can select individual rows instead of just a whole block of them (for instance, select just row 4, 7, 9 instead of 4-9). I can;t use Ctrl + click like I do with the columns.
Thanks!
1 L A T E S T R E P L I E S (Newest First)
Mike Buess
Posted - 11/01/2006 : 2:18:00 PM There is no easy way to operate on rows in Origin but you can transpose the worksheet (Edit > Transpose) and operate on the corresponding columns. To replace column 2 with the difference betwee column 2 and column 1 then select column 2, run Column > Set Column Values and enter the expression col(2)-col(1). If you want to put the difference into a new column insert a column wherever you want and set its values in the same way. When you're done transpose again to restore the original row/column order.