[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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"ghost" wrote:
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!!