Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Comparing 2 spreadsheets to find unique records

Resolved · High Priority · Version 2003

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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.

Excel articles

· Interesting Things About Charts In Excel 2003
· So what's new in Excel 2007?
· Data Validation In Excel
· How To Create A Real Line Graph In Excel 2010 Rather Than A Line Chart
· How to check for and reduce errors in Microsoft Excel

Please browse our web site to find out more about
microsoft+excel+training and other Microsoft training courses.

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips