| T O P I C R E V I E W |
| zskillz |
Posted - 10/11/2003 : 9:29:21 PM
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..
any ideas are warmly welcomed!
thanks
-Z |
| 2 L A T E S T R E P L I E S (Newest First) |
| Peter.Hors1 |
Posted - 10/21/2003 : 10:27:49 AM
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;}
};
Peter Horstmann
Robert Bosch GmbH
Germany |
| cpyang |
Posted - 10/11/2003 : 11:01:23 PM
If you just need to get the min/max of a dataset, you can use the Sum function, like
sum(col(a));sum.min=;sum.max=;
CP
|
|
|
