I have a question for you.....have you read the documentation on Formulas? If not, you need to read the Discovering JMP documentation
Help==>JMP Documentation Library Discovering JMP
Here is a modification to the previous formula
If( Row() == 1,
theGroup = {"WL15", "WL08", "WL06", "WL02", "WL01"};
counter = 1;
);
If(
Lag( :Group ) != :Group, counter = 1,
Lag( :rundate ) != :rundate, counter
++);
theGroup[counter];
I also suggest, that since the formula is based upon the order of the data, that once the formula is correctly run, that you go into the Column Info for the new column, and remove the formula from the column properties. This will leave the values, but will not rerun the formula if you change the order of the data
Jim