| Author |
 Topic  |
|
|
Fanning
UK
10 Posts |
 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 |
|
|
makub
Slovak Republic
2 Posts |
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 |
 |
|
|
Mike Buess
USA
3037 Posts |
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 |
|
|
|
Fanning
UK
10 Posts |
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 |
|
|
| |
Topic |
|
|
|
multiple column value changing