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 » Excel
Excel
Resolved · Medium Priority · Version 2007
Tue 3 Mar 2009, 15:44Delegate Alison said...
Alison has attended:
PowerPoint Introduction course
Excel
I receive a s/sheet each month with about 3500 entries on it. I would like to compare say the changes in column A that have taken place in the intervening period - for example between the Jan and Feb list. I would only need to look at the changes within that particular column and not the whole s/sheet. Can you advise if there is a simple way to do this and if so how.
Thank you for your assistance.
Kind Regards
Alison Fairley
Thu 5 Mar 2009, 13:19Trainer Amanda said...
RE: Excel
Hello Alison
Thank you for your question.
I believe Excel 2007 has an option within conditional formatting to highlight duplicates or unique entries. I think you would need to put both columns of data in the same spreadsheet for this to work, but I could be wrong.
Please note that in accordance with our fair use policy for the forum, that we are only supposed to answer questions that relate directly to the training you have undertaken with us; therefore we cannot guarantee that we will always be able to assist you with queries relating to applications and topics other than those covered on PowerPoint Introduction.
Kind regards
Amanda
Thu 12 Mar 2009: Automatically marked as resolved.
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:Closing Multiple Workbooks quicklyWhen you have several workbooks open in Excel and want to just close them all at once: |
