Hello, I have a question with excel. I am trying to do something that I cant figure out. I have 5 different people, trying to split 15 different things as equally as possible, percentage wise. Example: I order 50.....Bob order 30, jill order 75, ben orders 25, Jen orders 80. that comes to a total of 260. Now we together ordered 40 red, 25 blue, 100 pink, 50 green, and 45 black. Now we want to split that percentage wise, but it needs to hold out to whole numbers. I understand some have to round up and some down, so it wont be quite equal, but would there be a way to make it as equal as possible???
