count number in serial and break up serial count

[gondal]

dear all

PFA..i have data in column D this is in serial and break serial, i want in column L,M,N that if the serial is non breakable than first number in column L and last number in column M and total count of between numbers in column N..if there is only one number than same number in column L and M and count in column N is 1..

Gondal

[JohnTopley]

Used helper column


set h2=1

in H3 and copy down

=IF(D3=D2+1,"",MAX($H$2:H2)+1)

in R4

=IFERROR(INDEX($D$2:$D$15000,MATCH(ROWS($1:1),$H$2:$H$15000,0)),"")

in S4

=IFERROR(INDEX($D$1:$D$15000,MATCH(ROWS($1:2),$H$2:$H$15000,0)),"")

in T4

=S4-R4+1


Copy down

[gondal]

thnx John Topley..it is working .so nice