Comparing two spreadsheets

**Morten** · 10-20-2005, 03:50 PM

Hi I have a problem comparing two spreadsheets of data/names.

The problem:

I have two lists with account names and numbers in coulumns A and B on sheet 1 and 2
Sheet 1 and 2 differ from each other in contents as well as number of accounts.

Is it possible to compare the two sheets and show duplicate entries in a 3rd sheet??? (blanck sheet).
In addition the two lists have a huge amount of data which make comparing in the same sheet difficult.......

Have tried various formulas but have not yet succeded

Hope that some of you can help

**nsv** · 10-21-2005, 09:30 AM

Copy first columns A1 to B3147 (or whatever amount of lines there is) from Sheet 1 and paste them into Sheet 3!A1. The data will then lie in the same block as in Sheet 1.

Then copy A1 to B8116 ( or whatever amount of lines there is in this sheet) from Sheet 2 and paste them into Sheet 3 below the first ones. In this example they will lie in the block from A3148 to B11263.

In C1 write =IF(A1=A2;A1;""). Perhaps you must use comma instead of semicolon

Copy C1 all the way down and include also column D

Sort column A and B by A and you will see all the A duplicates in column C

Sort column A and B by B and you will see all the B duplicates in column D

Niels

Comparing two spreadsheets

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Comparing two spreadsheets

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions