Hi Lars,

One way to automatize this is to make an analysis template with recalculation settings. 
Since the Worksheet Query tool is actually the "wextract" x-function, you can put this 
as a part of recalculation such that (as in the screenshot below): 

1) Add an extra column, F. Open its Set Column Value tool, and enter the following 
command into the "Before Formula Scripts" box: 
  wextract iy:=[Book1]Sheet1!(1:end) 
    settings.stAlias.Cols:=5 
    settings.stAlias.AliasNames:=E 
    settings.stCondition.Condition:="E=1" 
    settings.cols:="0|1|2";
  This command does the exactly the same in my previous post. No formula in the main box!
  Set this Set Col Values tool's Recalculation mode to "Auto" (as the green lock icon tells).
  Click OK to save.
  (For the infomation about wextract, open the X-function help, and go to: 
     X-Function> Data Manipulation> Worksheet> wextract )
2) Also for columns D and E, set their Set Col Values tool's Recalculation mode to "Auto". 
  Try to update the data in columns C, or import data into column A, B, and C, 
  and observe that a new extracted worksheet is created. 

3) Save the worksheet as an Analysis Template by "File: Save Workbook as Analysis Template" menu. 

Now, you always open this template, and enter your new data, you get the result automatically.



--Hideo Fujii
OriginLab

P.S. Sorry for that there was a type in my previous post. The formula for column should read: 
  abs(col(C)[i]-col(C)[i-1])

Hi Lars,

There may be a smarter way, utilizing the conditional operator: 
  <Condition>?<VALUE_on_TRUE>:<VALUE_on_FALSE>
please try the following procedure (See the sample in the screenshot): 

1) Add two columns. (Column D and E).
2) Using the Set Column Value tool for column D to detect the row of changing col(C). I.e.:
  abs(col(C)[i+1]-col(C)[i])
3) Using the Set Column Value tool for column E to detect the row of consequent changing col(D). I.e.:
  col(D)==1/0?1:(col(D)[i+1]==1?1:col(D)[i])
  (Here, the first test for the missing value(=1/0) was set only for the first row.)
4) Using the Worksheet Query tool ("Worksheet: Worksheet Query" menu), extract the rows which have the value 1 at column E.



Hope this works as what you envisioned.

--Hideo Fujii
OriginLab