samyscraps01
Board Regular
- Joined
- Jul 6, 2017
- Messages
- 56
I tried the formula below
=ROUNDUP(RANK($C27,Rando)/Sizes,0) and it works great for a list of people. I need this formula to work for a group of employees rather than a list of names. My chart below shows a group of employees in each department. So 42 represents one department, 19 another group of employees in another dept, and so forth. I want the formula to group together as evenly as possible all the departments and distribute them evenly into 6 main groups to be disbursed amongst 6 leaders. This is more than just taking the total of all the employees and dividing them into six even groups. I need as many departments grouped as evenly as possible into six buckets. Is there a way to do this? Even with another formula. I tried this formula with a list of employees and it worked really well but when I applied it to the EE's in Column B I did not get the same results.
<tbody>
</tbody>
=ROUNDUP(RANK($C27,Rando)/Sizes,0) and it works great for a list of people. I need this formula to work for a group of employees rather than a list of names. My chart below shows a group of employees in each department. So 42 represents one department, 19 another group of employees in another dept, and so forth. I want the formula to group together as evenly as possible all the departments and distribute them evenly into 6 main groups to be disbursed amongst 6 leaders. This is more than just taking the total of all the employees and dividing them into six even groups. I need as many departments grouped as evenly as possible into six buckets. Is there a way to do this? Even with another formula. I tried this formula with a list of employees and it worked really well but when I applied it to the EE's in Column B I did not get the same results.
Dept No. | EE | Random | Buckets | Name List | |
91230 | 42 | 0.583587226 | 3 | Sizes | 6 |
91231 | 19 | 0.829519086 | 1 | | |
91232 | 35 | 0.393358531 | 3 | | |
91233 | 57 | 0.775741312 | 2 | | |
91234 | 25 | 0.141453984 | 4 | | |
91235 | 23 | 0.023805453 | 4 | | |
91236 | 39 | 0.511275187 | 3 | | |
91237 | 47 | 0.212964913 | 4 | | |
91238 | 7 | 0.23715932 | 4 | | |
91239 | 3 | 0.774636135 | 2 | | |
91240 | 18 | 0.52070436 | 3 | | |
91241 | 17 | 0.300847994 | 4 | | |
91242 | 2 | 0.841505214 | 1 | | |
91243 | 36 | 0.789073292 | 1 | | |
91244 | 101 | 0.825132871 | 1 | | |
91245 | 13 | 0.886795114 | 1 | | |
91246 | 15 | 0.704440553 | 2 | | |
91247 | 28 | 0.733682216 | 2 | | |
91248 | 4 | 0.280399365 | 4 | | |
91249 | 48 | 0.326471943 | 3 | | |
91250 | 1 | 0.576338148 | 3 | | |
91251 | 12 | 0.695422989 | 2 | | |
91252 | 21 | 0.676249387 | 2 | | |
91253 | 14 | 0.857909903 | 1 | |
<tbody>
</tbody>