Clemens,
See if the following works for you.
1) In the worksheet you show in the screenshot above, add 2 columns (cols 5 & 6) making them X and Y. Give them whatever long name you wish.
2) For col 5, open the Set Column Values dialog by right-clicking on the column header.
3) Add the script below to the "Before Formula Scripts" field.
4) Leave the other field empty.
5) Set Recalculate to "Auto".
6) Click OK to close the dialog.
Now, when values are added to both cells 1 & 2 of column 3 (your bounds), the data will be automatically differentiated into cols 5 & 6 and the maximum value will be put into the Comments for column 6.
You can now use this workbook as a template (the Set Column Value script will be saved).
// Make sure both cells in column 3 have values
if ( ISNA($(Col(3)[1])) || ISNA($(Col(3)[2])) )
{
return;
}
// Now do the differenitate your data
differentiate iy:=(Col(1),Col(2))[x$(Col(3)[1]):$(Col(3)[2])] oy:=(Col(5),Col(6));
// Get max value of differentiated data
double dMax = Max(Col(6));
//Round the max value to the default system decimal digits and display maximum value in comments for column 6
dMax = round(dMax, system.numeric.numDecDigits);
Col(6)[C]$ = "Max: $(dMax)";
~Chris
