Evenly distribute a number across several cells

**gbursson** · 02-07-2015, 04:39 AM

Hi,

I have a problem to solve, I was hoping you can help me with it.

I have a number of blood samples (let's say 52) to distribute evenly across up to 6 centrifuges. Of course, this could mean some of the centrifuges would get one more, and some one less sample to work on.

Number of samples could change, same as number of centrifuges.

I tried to solve it by using QUOTIENT(samples,centrifuges) and MOD(samples,centrifuges) functions, but am stuck at the moment.
QUOTIENT would be the first 'round' of sampling, equally distributing same amount across the board. How to distribute the reminder (MOD result) among them?

Anyone able/willing to help?

**zbor** · 02-07-2015, 04:42 AM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**gbursson** · 02-18-2015, 05:51 AM

Hi zbor,

Thanks for the reply, I think I managed to do it.

I get base number of samples going to each centrifuge by using QUOTIENT function.
Then, I start distributing reminder of the division one by one across centrifuges until there is none left.
I add base number + calculated modulo for each centrifuge to get the final quantity.

Regards,
Greg.