I need to read the first and last values in colA of a data set. the first is simple enough, but how can I read what the last value is if there are more rows in the dataset then there are values in the column...
just to clarify. I have a data set w/ 8 rows...
1 2 3 4 5 [blank] [blank] [blank]
and i want to read 1 and 5 and set them to a min and max variable...
alternatively... I know that these values will be the minimum and maximum, respectively, of the data set... however, i cannot seem to find a way to read the "max" or "min" value of a data set..
Without blanks this works (think you know that): get data1_B -e last; last=;
With blanks this works if you dont have any blank in between: for (i=1;i<=wks.nrows;i++) { if(data1_B[i]==) {type found last one in row $(i-1)!; break;} };
reading the first and last values of a dataset...
Posted - 10/11/2003 : 9:29:21 PM
