Forum home » Delegate support and help forum » Microsoft Excel Training and help » learn excel in london - Solver

learn excel in london - Solver

ResolvedVersion Standard

Fri 24 Nov 2006, 18:34 Delegate Ronak said...

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

Tue 28 Nov 2006, 14:53 Edited on Wed 29 Nov 2006, 16:06 Trainer Amanda said...

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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips

learn excel in london - Solver

Solver

RE: solver

Excel articles

Excel tip:

Using Alt in Save Dialog Box