hello,
i am trying to distribute items to people based on the value of the item.
example: of how i would manually distribute the item to the people.
PEOPLE:
bob
joe
steve
ITEM LIST
item 1: 10 points - BOB
item 2: 5 points -STEVE
item 3: 5 points -STEVE
item 4: 3 points -JOE
item 5: 4 points -JOE
total: 27 points
is there a way to make excel automatically assign the names of the people to the items and get them equally distributed as possible, its doesn't have to distributed perfectly.
thanks.
Bookmarks