98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Lists
Lists
Resolved · Low Priority · Version 2003
richard has attended:
Excel Intermediate course
Lists
I need A good formula for comparing two lists of data
RE: Lists
Hello Richard
Thank you for your question
When you say you want to compare the two lists, how exactly do you want to compare them as this can greatly affect the formula you will use. For example, if you want to check if values on one list exist on the other list already so you can merge them then you would use a vlookup formula. If you are comparing them in another way then you might use a different formula. Could you be more specific and perhaps provide a sample of what you would like to do?
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
RE: Lists
Hi,
we need to compare two lists of file references in the following format.
List Updated List
01/002/0003 01/02/0003
Regards,
Richard.
RE: Lists
Hello Richard
You wont be able to compare two lists like this based on completely different IDs. What i suggest is that the original ID is placed on the new list next to the updated ID. You will then be able to use vlookup to see if something from one list is on the other list. A bit of ground work required here, but there are a couple of formulas that might help make it a bit easier. I have attached a sample spreadsheet to demonstrate how to do this.
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
Attached files...
Mon 2 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:Change the Default Width of All Columns in Excel 2010If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how: |