Create sequential

[#1]

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

[#2]

Here is one form of a formula that will work

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

[#3]

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

[#4 · Accepted solution]

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

[#5]

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