| Author |
 Topic  |
|
|
19102208
Germany
Posts |
 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.
|
|
|
larry_lan
China
Posts |
Posted - 07/21/2009 : 08:01:09 AM
|
Use column index, like: col(a)[1], col(b)[2], etc.
Larry
OriginLab Technical Services |
 |
|
|
19102208
Germany
Posts |
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
China
Posts |
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
Germany
Posts |
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)
|
|
|
|
easwar
USA
1964 Posts |
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 |
|
|
| |
Topic |
|
Column-cells access?