SM2011
asked on
Excel formula
I am looking to see if there is a funstion available in Microsoft Excel 2010. I have a balancing issue and want to make the figures balance.
Current I have a colum of cells (P) with 1786 rows. The total for the column is totaling 31,942.93. I want to find out what combination of these cells/figures could be used to make 54.17. Is there a formula availabvle to do this.
Current I have a colum of cells (P) with 1786 rows. The total for the column is totaling 31,942.93. I want to find out what combination of these cells/figures could be used to make 54.17. Is there a formula availabvle to do this.
There is no function in Excel for that!
you would need a macro
is there a specific number of cells that should add up to 54.17?
is there a specific number of cells that should add up to 54.17?
ASKER
No Specific number cells. Any combination of cells or to show me all possible combination of cells.
I think that the best option is to avoid using a normal computer program to do this. The combination count is so high that no computer can complete this task in any reasonable time frame.
Some sort of artificial intelligence can might be appropriate but I do not think such a thing is readily available.
At the moment such things are best done by visual judgement.
Some sort of artificial intelligence can might be appropriate but I do not think such a thing is readily available.
At the moment such things are best done by visual judgement.
Find someone who really needs to get a life and hire him to do it.
:)
:)
You want to 'make the figures balance', against what ? The only way to achieve a reconciliation is to compare underlying figures so we need to understand both sides in order to extract the differences
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Maybe you could filter the list of 1786 records to those which themselves have value 54.17 or less, to start with. Just a tip to make life easier for the CPU.
You could also filter to only show those that have 54.17 minus whatever the lowest value is.
@ etech0: Even better!
Unless and except 54.17 is in the list! :)
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.