98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Matching data
Matching data
Resolved · Medium Priority · Version 2003
Fri 25 Jul 2008, 15:55Delegate Gerald said...
Gerald has attended:
Excel Advanced course
Matching data
If you have 2 colums of data ( Numbers), and you need to identify the diffenrences betweeb column a and B, and all you need to see are the changes. Is there a way Excel can run down column A look for a match in column B, and list those that do not match between columns a&B
Fri 25 Jul 2008, 17:11Trainer Amanda said...
RE: Matching data
Hi Gerald
Thank you for your question; and welcome to the forum.
You can use an IF function to compare a number in one column with a number in another column, then display what the difference between the two numbers is if there is one.
I've attached an example for you to have a look at - you are welcome to reply with your comments. Chances are if you are looking for something which is more complex it would require VBA programming which is outside of the scope of the Excel Advanced course.
Kind regards
Amanda
Attached files...
differences example.xls
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:Remove unused toolbar buttonsAre there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following: |
