how to select group of 77 number

[ghost]

Greeting,

I have 2851 item that need to be grouped per 77 numbers. What I want to do
is selecting the first 11 numbers of 77 and gives them the number start from
1.1 to 1.11 after that second 11 number is giving 2.1 to 2.11 and so on to
7.11. is there any code that can conduct the two functions as one go(group by
77 item and number them)

Thanks!!

 

[Max]

Perhaps you meant something like this
Place in any starting cell, eg in B2:
=INT((ROWS($1:1)-1)/11)+1&"."&MOD(ROWS($1:1)-1,11)+1
Copy down 77 rows to B78 to generate the text numbering: 1.1 ... 7.11