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.
 
Ad

Advertisements

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...
 
Ad

Advertisements

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.
: > : > :
: > : >
: > : >
: > :
: >
: >
: >
 
Ad

Advertisements

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
Excel Sum numbers in cells that also contain text 34
Excel How to add numbers in same cell? 2
Complicated Formula Problem 10
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Formula's 2
Set add function ignore #N/A 1
subtract entries from allocated total until it reaches zero 1

Top