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.

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

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")

See attached workbook.

please help me


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

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.

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

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.

You can download DiffEngineX from

http://www.florencesoft.com/excel-di...-download.html

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.