This little script will give you a data table with all the min and max date rows with their values of median_resultval
names default to here(1);
dt=current data table();
// Sort the data by reagentMLot_sublot and Date
dtSort = dt << sort(by(:reagentMLot_sublot, :Date),order(ascending,ascending));
dtSort << clear rowstates;
// Loop through the data finding all rows that are not the minimum date or the maximum date
// and delete them
// Row 1 will always be a minimum date, so start with row 2
For( i=2,i<=NRows(dtSort) - 1,i++,
If( dtSort:reagentMLot_sublot[i] == dtSort:reagentMLot_sublot[i-1] &
dtSort:reagentMLot_sublot[i] == dtSort:reagentMLot_sublot[i+1],
Row State( i ) = Selected State( 1 );
)
);
dtSort << delete rows;
You should be able to take it from there, and display it in the form you want it to be displayed.
Jim