| T O P I C R E V I E W |
| Fanning |
Posted - 06/27/2003 : 03:32:44 AM
Hi,
My data has hundreds of columns, and I need to subtract the value of the first row from all rows in every single column, in another word, to zero the starting point. I know I can do it one by one by using "set column value", but it is just too painful!
Could anyone help me to write a script for this, since I haven't got a clue. By the way, I am using origin 6.1.
Thanks a lot in advance.
Fanning |
| 3 L A T E S T R E P L I E S (Newest First) |
| Fanning |
Posted - 06/27/2003 : 08:38:48 AM
Hi, Mike
Thanks ever so much. It works. Such a script might be easy for you, but it's just a mission impossible for me. Many thanks to Majo too.
Cheers
Fanning |
| Mike Buess |
Posted - 06/27/2003 : 08:19:26 AM
Hi Fanning,
It'd be much easier to use this simple LabTalk script...
loop (ii,1,wks.ncols) {
%(%H,ii)-=%(%H,ii,1);
};
Just copy/paste it to the script window, highlight and press enter.
Mike Buess
Origin WebRing Member
Edited by - Mike Buess on 06/27/2003 08:21:12 AM |
| makub |
Posted - 06/27/2003 : 07:18:54 AM
Hi Finning,
have you tried to do it in Excel (by simple macro) and then to copy data into Origin?
Majo |
|
|
