topic Re: Create sequential in Discussions

Create sequential

Sibtid — Wed, 08 May 2019 09:47:42 GMT

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

Re: Create sequential

txnelson — Wed, 08 May 2019 13:16:30 GMT

Here is one form of a formula that will work

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

Re: Create sequential

Jeff_Perkinson — Wed, 08 May 2019 13:26:18 GMT

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

Re: Create sequential

gzmorgan0 — Thu, 09 May 2019 00:31:11 GMT

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.

Re: Create sequential

Sibtid — Thu, 09 May 2019 02:52:27 GMT

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.