cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Sibtid
Level II

Create sequential

I have data as below (column A, B, and C), I would like to create sequence column by add formula.

 

2019-05-08 16_44_37-Book5 - Excel.png

1 ACCEPTED SOLUTION

Accepted Solutions
gzmorgan0
Super User (Alumni)

Re: Create sequential

If you are trying to create the sequence column, here is the formula that recreates the column you showed. It is based upon the formula @txnelson  provided. 

 

Attached is the table and the Sequence column with a formula. 

image.png

View solution in original post

4 REPLIES 4
txnelson
Super User

Re: Create sequential

Here is one form of a formula that will work

if(row()==1, x=0);
If(:c==0, x=x+1);
x;
Jim
Jeff_Perkinson
Community Manager Community Manager

Re: Create sequential

The Sequence() function is what you're looking for.

-Jeff
gzmorgan0
Super User (Alumni)

Re: Create sequential

If you are trying to create the sequence column, here is the formula that recreates the column you showed. It is based upon the formula @txnelson  provided. 

 

Attached is the table and the Sequence column with a formula. 

image.png

Sibtid
Level II

Re: Create sequential

Thanks all for solve my problem. I try all solution that you provide and gzmorgan0's formula is the best match my problem.


@gzmorgan0 wrote:

If you are trying to create the sequence column, here is the formula that recreates the column you showed. It is based upon the formula @txnelson  provided. 

 

Attached is the table and the Sequence column with a formula. 

image.png


2019-05-09 09_40_38-Untitled 144 - JMP [2].png