Thread: how to select group of 77 number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default how to select group of 77 number
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!!
Reply With QuoteReply With Quote