ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Analyze total (https://www.excelbanter.com/excel-programming/368366-analyze-total.html)

ln54

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 ?

ADG

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