| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Divide a list into Groups
I need divide a list of 500 lines into groups of 8 and assign a number or
name to each group |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Divide a list into Groups
This requires a simple macro. Do you want a space inbetween each group. How
do you want to assign a number? Write the number in column A? Need a little more details to get it right. "SerpentineFire" wrote: I need divide a list of 500 lines into groups of 8 and assign a number or name to each group |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Divide a list into Groups
No space needed. I have 500 lines that i need evenly divided in to 8 groups.
So line 1-62 is assigned group 1 (or # 1) 63-124 group 2 and so on... The group number would be in Column A. Hope this is enough Details "Joel" wrote: This requires a simple macro. Do you want a space inbetween each group. How do you want to assign a number? Write the number in column A? Need a little more details to get it right. "SerpentineFire" wrote: I need divide a list of 500 lines into groups of 8 and assign a number or name to each group |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Divide a list into Groups
Sub number_groups()
Const NumLines = 500 Const NumGroups = 8 GroupSize = Int(NumLines / NumGroups) GroupNum = 1 For Lines = 1 To NumLines GroupNum = WorksheetFunction.RoundUp(Lines / GroupSize, 0) Range("A" & Lines) = GroupNum Next Lines End Sub "SerpentineFire" wrote: No space needed. I have 500 lines that i need evenly divided in to 8 groups. So line 1-62 is assigned group 1 (or # 1) 63-124 group 2 and so on... The group number would be in Column A. Hope this is enough Details "Joel" wrote: This requires a simple macro. Do you want a space inbetween each group. How do you want to assign a number? Write the number in column A? Need a little more details to get it right. "SerpentineFire" wrote: I need divide a list of 500 lines into groups of 8 and assign a number or name to each group |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to divide a number into groups of thousands | Excel Discussion (Misc queries) | |||
| List Sorted/Split into groups | Excel Worksheet Functions | |||
| Ranking a List which must be within GROUPS | Excel Discussion (Misc queries) | |||
| divide a large group of people into smaller groups by their vote | Excel Discussion (Misc queries) | |||
| Excel formula divide list of #s by N to get a number above 40 | Excel Discussion (Misc queries) | |||
Linear Mode
