I'm looking for a formula or set of formula to find how many numbers are found to be sequential.
See picture for example of what i'm looking for
Ive found the following formula that identifies what numbers are sequential. but it doesnt tell how many are in each range
=IF(A3=A2+1,C2,IF(A3=A4-1,MAX(C$1:C1)+1,""))
I use a helper column for this and the first row must be empty to get the correct result in the first data row.(reference to the previous row)
In the example data are in A2:A18, adjust the range for MATCH as required.
In B2: =IF(--OR(A2=(A3-1),A2=(A1+1))>0,MATCH(0,B3:B$18,0),0)
In C2: =IF(B2>0,MAX(C1,B2),0)
and copy down.