Hi,
i want to create unique lists of 20 people but i can't figure it out the magic formula.
so... i have this table.
in each depart are a number of people.
how can i split them automatically? for ex. in depart 1, after 3 months, will be 10 people, they will be splited right?
can you please help me?
thank you very much!!
[TABLE="width: 403"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Department
[/TD]
[TD]No of people[/TD]
[TD]%
[/TD]
[/TR]
[TR]
[TD]Depart 1[/TD]
[TD]2[/TD]
[TD]0.8%[/TD]
[/TR]
[TR]
[TD]Depart 2[/TD]
[TD]24[/TD]
[TD]9.8%[/TD]
[/TR]
[TR]
[TD]Depart 3[/TD]
[TD]7[/TD]
[TD]2.8%
[/TD]
[/TR]
[TR]
[TD]Depart 4[/TD]
[TD]20[/TD]
[TD]8.1%[/TD]
[/TR]
[TR]
[TD]Depart 5[/TD]
[TD]4[/TD]
[TD]1.6%[/TD]
[/TR]
[TR]
[TD]Depart 6[/TD]
[TD]16[/TD]
[TD]6.5%[/TD]
[/TR]
[TR]
[TD]Depart 7[/TD]
[TD]6[/TD]
[TD]2.4%[/TD]
[/TR]
[TR]
[TD]Depart 8[/TD]
[TD]14[/TD]
[TD]5.7%[/TD]
[/TR]
[TR]
[TD]Depart 9[/TD]
[TD]16[/TD]
[TD]6.5%[/TD]
[/TR]
[TR]
[TD]Depart 10[/TD]
[TD]3[/TD]
[TD]1.2%
[/TD]
[/TR]
[TR]
[TD]Depart 11[/TD]
[TD]54[/TD]
[TD]22.0%[/TD]
[/TR]
[TR]
[TD]Depart 12[/TD]
[TD]1[/TD]
[TD]0.4%[/TD]
[/TR]
[TR]
[TD]Depart 13[/TD]
[TD]36[/TD]
[TD]14.6%[/TD]
[/TR]
[TR]
[TD]Depart 14[/TD]
[TD]43[/TD]
[TD]17.5%[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]246[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
i want to create unique lists of 20 people but i can't figure it out the magic formula.
so... i have this table.
in each depart are a number of people.
how can i split them automatically? for ex. in depart 1, after 3 months, will be 10 people, they will be splited right?
can you please help me?
thank you very much!!
[TABLE="width: 403"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Department
[/TD]
[TD]No of people[/TD]
[TD]%
[/TD]
[/TR]
[TR]
[TD]Depart 1[/TD]
[TD]2[/TD]
[TD]0.8%[/TD]
[/TR]
[TR]
[TD]Depart 2[/TD]
[TD]24[/TD]
[TD]9.8%[/TD]
[/TR]
[TR]
[TD]Depart 3[/TD]
[TD]7[/TD]
[TD]2.8%
[/TD]
[/TR]
[TR]
[TD]Depart 4[/TD]
[TD]20[/TD]
[TD]8.1%[/TD]
[/TR]
[TR]
[TD]Depart 5[/TD]
[TD]4[/TD]
[TD]1.6%[/TD]
[/TR]
[TR]
[TD]Depart 6[/TD]
[TD]16[/TD]
[TD]6.5%[/TD]
[/TR]
[TR]
[TD]Depart 7[/TD]
[TD]6[/TD]
[TD]2.4%[/TD]
[/TR]
[TR]
[TD]Depart 8[/TD]
[TD]14[/TD]
[TD]5.7%[/TD]
[/TR]
[TR]
[TD]Depart 9[/TD]
[TD]16[/TD]
[TD]6.5%[/TD]
[/TR]
[TR]
[TD]Depart 10[/TD]
[TD]3[/TD]
[TD]1.2%
[/TD]
[/TR]
[TR]
[TD]Depart 11[/TD]
[TD]54[/TD]
[TD]22.0%[/TD]
[/TR]
[TR]
[TD]Depart 12[/TD]
[TD]1[/TD]
[TD]0.4%[/TD]
[/TR]
[TR]
[TD]Depart 13[/TD]
[TD]36[/TD]
[TD]14.6%[/TD]
[/TR]
[TR]
[TD]Depart 14[/TD]
[TD]43[/TD]
[TD]17.5%[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]246[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]