Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007
|
|
|
The UK's most regular 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 2007
Resolved · Low Priority · Version 2007
Reply Fri 18 Feb 2011, 17:06Delegate Paul said...
Paul has attended:
Excel Advanced course
Excel 2007
I extract data from a database into an excel report that is 2 columns, one for customer, one for sales. If the sales figure for a couple of customers changes after a few days (or another customer si added to the figures) I want to compare the two sets of sales figures and show the differences please?
For upcoming training course dates see: Pricing & availability
RE: Excel 2007
Hello Pau,
Hope you enjoyed your course with BEST Training.
Thank you for your question regarding comparing columns.
This particular question would require development work as it may not be as straightforward as you explain.
As a starting point, you would need to import the new data columns into the sheet or other sheet so they can be compared. Its possible to use If function, such as =IF(B3=H3,0,H3-B3). The first part compares a figure in B3 with H3, if they match then its true, so performs the 0, if they are different, false, it takes one cell from other to show the difference!
However, it would need more work to check new entries etc..
Hope this gives you a starting point.
if it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
|