nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create sequential

Sibtid

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

Accepted answers

gzmorgan0

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.

CreateSequential.jmp

All comments

txnelson

Here is one form of a formula that will work

if(row()==1, x=0);
If(:c==0, x=x+1);
x;

Jeff_Perkinson

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

gzmorgan0

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.

CreateSequential.jmp

Sibtid

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.

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