thedeadzeds
Active Member
- Joined
- Aug 16, 2011
- Messages
- 442
- Office Version
- 365
- Platform
- Windows
Guys, im pretty sure this is not possible but wanted to check. I have a list of vehicles in column A and a list of 4 names in D1:D4 (dave, bob, jim and steve). I was wondering if it is possible to allocate the vehicles equally to the people named in D1:D4 so each person has an equal amount of vans, cars, bus and bikes. The results would be shown in column B. I do realise that it cannot always be an equally split but as close to as possible would be ok. Hope this makes sense. Thanks
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
<tbody>
</tbody>
<colgroup><col><col></colgroup><tbody>
</tbody>
Dave |
Jim |
Steve |
Bob |
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
<tbody>
</tbody>
Veh | Allocated |
van | |
van | |
van | |
van | |
van | |
van | |
Car | |
Car | |
Car | |
Car | |
Car | |
Car | |
Car | |
Car | |
Car | |
Car | |
Car | |
bus | |
bus | |
bike | |
bike | |
bike | |
bike | |
bike | |
bike | |
bike | |
bike | |
bike |
<colgroup><col><col></colgroup><tbody>
</tbody>