![]() |
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 ? |
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 ? |
All times are GMT +1. The time now is 11:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com