learn excel in london - Solver

Resolved · Low Priority · Version 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:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips