LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How to ID numbers in Excel sheet that add up to specific sum?

For account reconcilation purposes...

Basically, given a list of up to 50 numbers (each cell contains a number),
the goal is to find 1-5 numbers from that list that add up to a single sum.

So if 5, 10, 15, 20, 1, 2, 18, and 3 were on my list, and I wanted to know
what adds up to 18, it would return the following combinations of numbers
from my list add to 18:

18
5, 10, and 3
5, 10, 1 and 2
15, 1, and 2
15 and 3

I don't need it to identify which cells contain these numbers, just tell me
which numbers from my list add up to the sum I give it. A program to
identify it would be nice, but not necessary.

A few more things:

1.) The program should not use the same cell twice in the caluculation. (So
it should not tell me that 5, 5, 5, and 3 make 18, if 5 is only listed once
in my list. It could if the number 5 occurs in 3 different cells.
2.) I should be able to change how many numbers it tries to combine. (so I
can limit it to only comparing 2 numbers, or increase it up to finding up to
5 numbers that add up to a specific total.)
3. I should be able to control which numbers from the list are compared.
4.) The program should not subtract numbers to get the total requested.

Mission Impossible? Or just complicated? I've heard there's ways to make
solver do this, but I haven't found a solution yet.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Force excel to open on a specific sheet harwookf Excel Worksheet Functions 5 November 16th 07 04:48 PM
Opening A Specific Excel Sheet [email protected] Excel Discussion (Misc queries) 2 July 11th 05 08:45 PM
Highlight a row if a specific cell is specific numbers/words sea0221 Excel Worksheet Functions 2 March 9th 05 12:06 AM
hyperlink to specific sheet in excel mango Excel Worksheet Functions 1 December 9th 04 11:17 AM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM


All times are GMT +1. The time now is 01:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"