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
 All Forums
 Origin Forum
 Origin Forum
 How to get the end value of a column ?

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
polal2is Posted - 04/14/2008 : 06:23:10 AM
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
2   L A T E S T    R E P L I E S    (Newest First)
polal2is Posted - 04/15/2008 : 03:41:13 AM
Thanks I'll try but can I use this in "before formula script" section ?
Echo_Chu Posted - 04/15/2008 : 01:44:41 AM
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

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000