Calculation query

[rocaman]

I ahve a list of 102 numbers ranging from 1.00 to 2000.00. I need to identify which group of these numbers add up to a set total of 3800.00. is there a means of Excel of doing this.

Thanks

 

[VoG]

This should help you http://www.tushar-mehta.com/excel/templates/match_values/index.html

 

[Andrew Poulsom]

Look here:

http://www.tushar-mehta.com/excel/templates/match_values/index.html

 

[rocaman]

This should help you http://www.tushar-mehta.com/excel/templates/match_values/index.html

Thanks but code too complicated for me and solver template takes largest number and percentage of next largest number to reach solution. I'm missing something but thanks anyway