# how to find differences between 2 excel sheets

1. ## how to find differences between 2 excel sheets

I have 2 excel sheets with email addresses, many of the same email addresses appear on both sheets. i want to know which addresses are on sheet A but not on sheet B.

2. ## Re: how to find differences between 2 excel sheets

Hi,

Lets assume that the email addresses in sheet A & sheet B are listed in column A, then in column B sheet A put this code:

=IF(VLOOKUP(A1,'Sheet B'!A:B,2,FALSE),"","Available in B").

There are some better ways than this I provided, but I think you can work with this for now

Please find attached for easy reference

3. ## Re: how to find differences between 2 excel sheets

thats got an error as it looks to col b on sheet b
use =if(isnumber(match(a1,sheet2!a:a,0)),"on sheet 2","not on sheet 2")

4. ## Re: how to find differences between 2 excel sheets

See attached workbook.

5. ## Re: how to find differences between 2 excel sheets

i want to compare sheet2 to sheet1 and then sheet3 must see the difference
isaw your file but i cann't coppy there anything i want that i copy to sheet1 and new information in sheet2 and then the difference see in sheet3

how can i do this.

plaese help me

6. ## Re: how to find differences between 2 excel sheets

bet555

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

7. ## Re: how to find differences between 2 excel sheets

Many thanks Malnahar! That worked perfectly for me.

Originally Posted by malnahar
Hi,

Lets assume that the email addresses in sheet A & sheet B are listed in column A, then in column B sheet A put this code:

=IF(VLOOKUP(A1,'Sheet B'!A:B,2,FALSE),"","Available in B").

There are some better ways than this I provided, but I think you can work with this for now

Please find attached for easy reference

8. ## Re: how to find differences between 2 excel sheets

Well if you use the Data tab or menu to make sure both worksheets are in sorted order and then save the changes, you can use DiffEngineX. After making sure you are familiar with what it does you can then bring up its Extras dialog and turn on Hide Matching Rows.

DiffEngineX will produce two color highlighted sheets. Look at the sheet that corresponds to your sheet A.

Just remember if your email addresses are in sorted order (if not get Excel to sort them with AZ sort under the Data tab, then save the changes) and Extras->Hide Matching Rows is turned on, DiffEngineX will tell you instantly what email addresses are in Sheet A but not Sheet B.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1