The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 How to get the end value of a column ?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

polal2is

France
Posts

Posted - 04/14/2008 :  06:23:10 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version (8.0773):
Operating System: Windows Vista SP1

Hi everyone,
I'd like to know if there's a way to get automatically the end value of a column for instance: I use the integrate fonction over a column so I get a new one filled with the area values and the end value of my new column will be the total area... If I want to use this total area value to fill a new column, I have to copy and paste this value manually which is a huge waste of time as I have hundreds of tasks to perform. So can I tell origin to use the end value each time even if the end value is not always at the same row. Sometimes 100th row or 101th...
I know that to use a particular cell the syntax is col(A)[i] for ith row. But in my case i is the number of my end row so how to tell origin to take the very last value : Col(A)[last value] ???
Hope to be understandable...
Thanks...

Edited by - polal2is on 04/14/2008 06:26:11 AM

Echo_Chu

China
Posts

Posted - 04/15/2008 :  01:44:41 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

The Labtalk script might help

get col(a) -e jj //get the end of col(a), set jj as lastest index
col(a)[jj] = //to get last value of col(a)

Echo
OriginLab Corp
Go to Top of Page

polal2is

France
Posts

Posted - 04/15/2008 :  03:41:13 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks I'll try but can I use this in "before formula script" section ?
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000