11.8 Take adjacent data as grouping criteria


Here below is a data table:


The task is to group the data in the first column, and calculate the sum of the values in the second column of each group. Grouping criteria: when there is a difference of 5 or more between the current data and previous one, create a new group:



esProc Desktop and Excel Processing
11.7 Convert one-dimensional array to two-dimensional array
11.9 Group when meeting blank row