Rounding to particular numbers

[herbc0704]

I am not sure if this has been discussed, I am sure it has but I am not sure what I am looking for. So bear with me and if it has please point me to the correct thread.

I have a table with total quantities shipped for line items. An analysis I have to takes into account that every 6 shipped is a case. So if I have 35 items in quantity it will be 6 cases and 5 eaches. 103 quantity would be 17 cases and 1 each. I have a spreadsheet with over 400,000 lines....Help Please.

 

[VoG]

Try like this

Excel Workbook
	A	B	C
1	Qty	Cases	Eaches
2	35	5	5
3	103	17	1
Sheet3

 

[shg]

# full cases =int(qty / qty per case)

# odd items = mod(qty, qty per case)

 

[herbc0704]

Thanks guys.