Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

comparing spreadsheets find

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Comparing 2 spreadsheets to find unique records

Comparing 2 spreadsheets to find unique records

ResolvedVersion 2003

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

Edited on Tue 23 Feb 2010, 10:40

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.

Excel tip:

Apply Autosum with keyboard shortcut

If you press Alt and = at the same time, it applies autosum.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.