The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

learn excel in london - Solver

Resolved · Low Priority · Version Standard

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

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

For upcoming training course dates see: Pricing & availability

ReplyTue 28 Nov 2006, 14:53 Edited on Wed 29 Nov 2006, 16:06Trainer 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

Excel articles

· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· How To Create An Excel Formula Using Data From Several Worksheets
· How To Identify The Most Critical Data In A Large Excel Spreadsheet
· Unsupported features in Excel 2007
· Advanced level training: Microsoft Excel and the Web

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips

Hi There
I have just done my training in Advanced 2007 - which has been very useful but I can't find out where you set the recording of a Macro in 2003 to Relative on the 2003 version (as opposed to Absolute, which I believe is the default setting) - I ..

» Forum post: Macros in Excel 2003

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions