| T O P I C R E V I E W |
| cts18488 |
Posted - 01/27/2022 : 08:42:49 AM
Origin Ver. 2021b and Service Release (Select Help-->About Origin): SR2
Operating System: Windows 10
Hi,
I was trying to add two columns from a book - Book1 with two columns from another one - Book2 - with the sum displayed in a third book - Book3 (please check the image below). I have tried to convert the book s into matrices and then do matrix addition from Script Command, but it didn't recognise the name of the matrices.
Is there a quick, reliable and error-free (as much as possible) way to do? Either through GUI, LAbTalk or Embedded Python? If yes, can I please have the step-by-step recipe on how to do it?
Regards,
Tibi
 |
| 2 L A T E S T R E P L I E S (Newest First) |
| cts18488 |
Posted - 01/27/2022 : 11:37:57 AM
Thank you!
quote:
Originally posted by snowli
Hello,
You can use enter this in F(x) cell of column B in Book3 to add B columns of Book1 and Book2.
[book1]1!B+[book2]1!B
See examples in https://www.originlab.com/doc/Origin-Help/Wks-SetColVal-QuickStart
Thanks, Snow
|
| snowli |
Posted - 01/27/2022 : 08:55:32 AM
Hello,
You can use enter this in F(x) cell of column B in Book3 to add B columns of Book1 and Book2.
[book1]1!B+[book2]1!B
See examples in https://www.originlab.com/doc/Origin-Help/Wks-SetColVal-QuickStart
Thanks, Snow
|
|
|
