98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » learn excel in london - Solver
learn excel in london - Solver
Resolved · Low Priority · Version Standard
Ronak has attended:
Excel Advanced course
Solver
Can I use the solver function to find from a set of accounting transactions the sum of debits or credits that sum up to a particular number. i.e. I have 100 transactions, from those transactions I need to find a combination of entries that sum up to
RE: solver
Hi Ronak
Thanks for your question.
The Solver feature will not be able to do this for you as Solver will change the entries in the cells in order to give you the solution you specify (e.g. total of
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Formst Excel to display leading zeroesSelect the cells that you want to have displaying leading zeroes. |