ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   20 different numbers want excel to determine which combo add to x (https://www.excelbanter.com/excel-discussion-misc-queries/162672-20-different-numbers-want-excel-determine-combo-add-x.html)

OCDN-IT

20 different numbers want excel to determine which combo add to x
 
I would like to have excel look at an array of numbers and determine which
ones add to a particular sum

Gary''s Student

20 different numbers want excel to determine which combo add to x
 
See:

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


--
Gary''s Student - gsnu200750


"OCDN-IT" wrote:

I would like to have excel look at an array of numbers and determine which
ones add to a particular sum


iliace

20 different numbers want excel to determine which combo add to x
 
On Oct 18, 3:41 pm, OCDN-IT wrote:
I would like to have excel look at an array of numbers and determine which
ones add to a particular sum


Just discussed this:

http://groups.google.com/group/micro...5d2d987b?hl=en

There's some VBA code that does this quite well.



All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com