To Group numbers from a list of numbers

Hii,

I require formula in grey coloured cells to give output as shown in D & E column.

The groupings are done until a break is found in continuous numbering.

If any further clarifications required feel free to ask me..

Thanks.

there will be a few ways to do this but one option:

Formula:

F3:

=IFERROR(AGGREGATE(15,6,($A$3:$A$16)/($A$3:$A$16<>($A$2:$A$15+1))/($A$3:$A$16>MAX($F$2:F2)),1),"")

copied down



G3:

=IF($F3="","",IF($F4="",MAX($A$3:$A$16),LOOKUP(F4-1,$A$3:$A$16)))

copied down

This is awesome!! Thanks for the solution!