have since found a template that uses solver for this problem on a previous
post:

http://www.tushar-mehta.com/excel/te...ues/index.html

however instead of matching several whole amounts it just returns a fraction
of 1 larger amount in the dataset as the solution. Anyone know how I can fix
this?

thanks.