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 » Comparing 2 spreadsheets to find unique records | Excel forum
Comparing 2 spreadsheets to find unique records | Excel forum
Resolved · High Priority · Version 2003
Thu 18 Feb 2010, 15:23Delegate Cherry said...
Cherry has attended:
Excel Intermediate course
Excel Advanced course
Comparing 2 spreadsheets to find unique records
Hi,
Please could you help with an enquiry? I have installed a duplicate checker in Excel that finds the duplicate fields in 2 excel spreadsheets. However this can be time consuming. Do you know of a much quicker way of comparing 2 similar spreadsheets to find the unique records? For example two spreadsheets with same layout, except that one spreadsheet may contain different data than the other.
Many thanks in advance.
Kind regards,
Cherry
Tue 23 Feb 2010, 10:38
Edited on Tue 23 Feb 2010, 10:40Trainer Jacob said...
RE: Comparing 2 spreadsheets to find unique records
Hi Cherry
After reviewing your post we can recommend two courses of action as your requirement is beyond the scope of this forum.
1) Attend our 2 day Excel VBA Introduction course, this will give you the skill sets required to create your own solution. More information, click here.
2) We create the solution for you, send us your working files with a list of objectives, we will confirm scope of work and related costs for you to decide on.
I hope this will suffice and if you have any further quesitons please contact us.
Regards
Jacob
Mon 1 Mar 2010: 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:Sorting List SubtotalsIf you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows. |
