BookmarkSubscribe
Choose Language Hide Translation Bar
Sibtid
Community Trekker

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

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
gzmorgan0
Super User

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

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

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

Highlighted
Sibtid
Community Trekker

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

0 Kudos