comparing two sheets

Curious

Board Regular
Joined
Aug 22, 2003
Messages
77
Good morning friends;

Does any one know of a utility that will compare two big sheets to see if there is any differences in the data.

I have imported data from two databases into two seperate sheets there are about 48 columns each and I want to make sure that I have not missed anything in either tables. Iknow there is a way to combine all the columns from each sheet and then compare, but we are talking a lot of columns.

:pray: :pray: :pray: :pray:
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
So, you want to campare sheet1 with sheet2 ?

In a 3rd sheet, you could have something like =if(sheet1!a1=sheets2!a1,"","Different) and copy through your used range.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,335
Messages
5,571,618
Members
412,409
Latest member
kellotheym
Top