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
 Maximum Value

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
DFingerhut Posted - 07/01/2011 : 03:52:33 AM
Hi,

I have a worksheet with 1000 Values in column A (row 1-1000). Now I would like to estimate the maximum value of column A and to put this value automatically into column B (row 1). I would like to use "set column values" istead of the descriptive statistics function, because so I have to copy and paste the values manually.
May somebody help me with this topic?

Thanks!
Daniel
5   L A T E S T    R E P L I E S    (Newest First)
naeem498 Posted - 05/08/2012 : 02:56:32 AM
Thank you very much. Its perfect.
Hideo Fujii Posted - 05/04/2012 : 2:25:26 PM
Hi,

You can set the range defined by the range notation such as:

range rr=col(A)[25:70];
sum(rr);
col(B)[1]=sum.max;

--Hideo Fujii
OriginLab
naeem498 Posted - 05/04/2012 : 11:02:30 AM
What if I want to have selective rows to choose from in column A. Lets say, from row 25-70 (in column A) I want to find maximum number and put it in B. Thanks
DFingerhut Posted - 07/02/2011 : 2:34:21 PM
Thank you!!!!!!
It works!!!
cpyang Posted - 07/01/2011 : 08:28:02 AM
You have to use the Before Formula Scripts

If this is used for col(A) and col(B) only, then put the following script into the Before Formula Scripts box in Col(B)'s Set Column Values dialog


sum(col(A));
col(B)[1]=sum.max;


You can then turn on Recalculate to Auto.

If you want this to be general, to calculate from previous column, then write it such that it can be applied to other columns:


sum(wcol(_ThisColNum-1));
wcol(_ThisColNum)[1]=sum.max;


To find out about the sum function in Labtalk, just google "labtalk sum" and it will land to this link

http://wiki.originlab.com/~originla/wiki/index.php?title=LabTalk:Sum_(object)

CP

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