reach a number from different combination

C

c_riss

I need to reach a number using different combinations from a number of cells.
For example cells filled in with numbers A:A100 and I need to know how excel
can identify the cells who can be sum to reach a fixed number.
 
T

Tom [Pepper] Willett

What's with all the Excel posts in the FP newsgroup?
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
: Perhaps this post would be better suited for the Excel forum?
:
: --
: Murray
: MVP Expression Web
:
:
: : >I need to reach a number using different combinations from a number of
: >cells.
: > For example cells filled in with numbers A:A100 and I need to know how
: > excel
: > can identify the cells who can be sum to reach a fixed number.
:
 
T

Tom [Pepper] Willett

Must be a bunch of 'em.

--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
: Poor readers?
:
: --
: Murray
: MVP Expression Web
:
:
: : > What's with all the Excel posts in the FP newsgroup?
: > --
: > Tom [Pepper] Willett
: > Microsoft MVP - FrontPage
: > ---------------------------
: > : > : Perhaps this post would be better suited for the Excel forum?
: > :
: > : --
: > : Murray
: > : MVP Expression Web
: > :
: > :
: > : : > : >I need to reach a number using different combinations from a number
of
: > : >cells.
: > : > For example cells filled in with numbers A:A100 and I need to know
how
: > : > excel
: > : > can identify the cells who can be sum to reach a fixed number.
: > :
: >
: >
:
 
C

c_riss

Hei both,

Get a dog if you feel the need to post stupid replies!
You must be so lonely...
 
T

Tom [Pepper] Willett

Hoople head.

: Hei both,
:
: Get a dog if you feel the need to post stupid replies!
: You must be so lonely...
:
: "Tom [Pepper] Willett" wrote:
:
: > Must be a bunch of 'em.
: >
: > --
: > Tom [Pepper] Willett
: > Microsoft MVP - FrontPage
: > ---------------------------
: > : > : Poor readers?
: > :
: > : --
: > : Murray
: > : MVP Expression Web
: > :
: > :
: > : : > : > What's with all the Excel posts in the FP newsgroup?
: > : > --
: > : > Tom [Pepper] Willett
: > : > Microsoft MVP - FrontPage
: > : > ---------------------------
: > : > : > : > : Perhaps this post would be better suited for the Excel forum?
: > : > :
: > : > : --
: > : > : Murray
: > : > : MVP Expression Web
: > : > :
: > : > :
: > : > : : > : > : >I need to reach a number using different combinations from a
number
: > of
: > : > : >cells.
: > : > : > For example cells filled in with numbers A:A100 and I need to
know
: > how
: > : > : > excel
: > : > : > can identify the cells who can be sum to reach a fixed number.
: > : > :
: > : >
: > : >
: > :
: >
: >
: >
 
C

catpol123

I need to reach a number using different combinations from a number of cells.
For example cells filled in with numbers A:A100 and I need to know how excel
can identify the cells who can be sum to reach a fixed number.
Click to expand...

Just use Excel add-in - SumMatch from SumMatch.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

REach o fixed number from different combinations 2
Remove numbers from brackets 0
Dealing with the error: unable to filter on excel hc home school 0
How to Create an S-Curve from Custom Field? 0
Creating Different Headers in Word 0
Centered text that does not stay centered 0
Custom Number sequences 0
Odd and even header and footers with section break 2

Top