I have looked around the forum for a solution to this problem but don't really know what function or formula I am looking for.

I want a formula or combination of formulae to calculate the least amount of wastage from 2 or more different size containers.

For example if I need 1045ml in total and have either a 100ml or a 160ml bottle I want to know which combination wastes the least amount of liquid.

What I really want to be able to do is to insert the required volume into a box and best fit combination of each bottle size to appear by the side.

If there is already a thread with the correct solution can someone please point me to it?

It maybe that this needs to be a macro with some limits on it. Or a lookup in a matrix but how to calculate the matrix easily is the next question!!!

Yours hopefully

Dr M