Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Analyze total
I want to know what combinations of a lot of
transactions are equal to a specific sum total. How can I do this ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Analyze total
Hi
With a large no of transactions and an unknown number of elements in the total the maths on this makes this too long a process. For example the lottery has 49 numbers (transactions), and you can select 6 numbers in nearly 14 million different ways (possibly the same as say 6 lines that make up your total). Your problem is worse, as you don't know how many make up the total and I guess you have more than 49 lines to check. To work through all possible combinations would be many millions of tests, even if you do some total checking logic as you work through. -- Tony Green "ln54" wrote: I want to know what combinations of a lot of transactions are equal to a specific sum total. How can I do this ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't analyze web data | Excel Worksheet Functions | |||
how to analyze data? | Excel Discussion (Misc queries) | |||
analyze list | Excel Worksheet Functions | |||
Analyze Data | Excel Worksheet Functions | |||
How do I calcuate an IC50 from analyze it? | Excel Worksheet Functions |