| T O P I C R E V I E W |
| 19102208 |
Posted - 07/21/2009 : 05:58:02 AM
How can I access certain cells in a column?
I can choose columns with "col(a)", is there something
similiar for cells?
Problem e.g.:
Col(a) - Col(b) - Operation
1 - 6 - 1/6
3 - 7 - 3/7
Thanks for help.
|
| 5 L A T E S T R E P L I E S (Newest First) |
| easwar |
Posted - 07/22/2009 : 1:23:24 PM
Hi,
You can use the index i which would represent row, as part of your formula, such as putting this as the formula for column C:
Col(C)=
(col(B)[i-1]-col(A)[i-1])/(col(B)[i]-col(A)[i])
Easwar
OriginLab |
| 19102208 |
Posted - 07/22/2009 : 07:57:27 AM
Sorry, that thas a misleading example.
I want to acces certain values in a column, which do not
correspond to the same line.
Col(a) - Col(b) - Operation
1 - 6 -
3 - 7 - (3-1)/(7-6)
|
| larry_lan |
Posted - 07/21/2009 : 9:20:44 PM
Well, in the "Operation" column in your example, you want to calculate:
Operation = Col(A) / Col(B)
right? If so, you can use the "Set Column Value" dialog in Origin. Right-click the column and select "Set Column Value". Please read this for how to use it.
Thanks
Larry |
| 19102208 |
Posted - 07/21/2009 : 09:16:46 AM
Ok, but how to automatically access the 2 cell then?
(as represented in the 2 line)
In Excel it is updated with drag and pop.
|
| larry_lan |
Posted - 07/21/2009 : 08:01:09 AM
Use column index, like: col(a)[1], col(b)[2], etc.
Larry
OriginLab Technical Services |
