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:

Please Login or Register  to view this content.

This is awesome!! Thanks for the solution!