Help me to find sequence pattern in excel

[Sakthikumar Chinnasamy]

Is there any formula to find seq pattern for the attached numbers?

 

[GraH - Guido]

Do you mean [B2]=RANK.EQ(B2,$B$2:$B$1048576)? And drag down.

 

[Sakthikumar Chinnasamy]

Hi G,

thank for your reply.. However i need to find the next sequence number from the last row value. for eg. last row value is 739728. Need to find next seq number.

 

[Peter Bartholomew]

I am at something of a loss to understand what is wanted here. Possible answers may include using Ctrl+L to turn the list into a table. Since what is labelled as 'SEQ' looks more like the output of a random number generator than a meaningful sequence, there is no guessing the next value; instead one might calculated its index:
= 1 + ROWS(Table1)
Out of curiosity, what is the number for which we are are trying to find a formula?

 

[GraH - Guido]

Hi G,

thank for your reply.. However i need to find the next sequence number from the last row value. for eg. last row value is 739728. Need to find next seq number.

and what that next sequence number be? Based on what increment?

 

[bosco_yip]

Maybe,

Using FORECAST.ETS function to predict the next seq number

1] Add serial number in column A (see attached file)

2] In B38, enter formula :

=FORECAST.ETS(A38,B2:B36,A2:A36)

then, the next seq number returned >> 740762

Regards
Bosco