+ Reply to Thread
Results 1 to 8 of 8

how to find differences between 2 excel sheets

  1. #1
    Registered User
    Join Date
    02-10-2009
    Location
    canada
    MS-Off Ver
    Excel 2003
    Posts
    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. #2
    Forum Contributor
    Join Date
    02-12-2008
    Location
    Doha-Qatar
    MS-Off Ver
    Excel 2007
    Posts
    137

    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
    Attached Files Attached Files

  3. #3
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    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. #4
    Forum Contributor
    Join Date
    10-11-2007
    Location
    Sweden
    MS-Off Ver
    365
    Posts
    251

    Re: how to find differences between 2 excel sheets

    See attached workbook.

  5. #5
    Registered User
    Join Date
    04-22-2011
    Location
    Tbilisi, Georgia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: how to find differences between 2 excel sheets

    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

  6. #6
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    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. #7
    Registered User
    Join Date
    06-06-2012
    Location
    San Francisco, via Detroit
    MS-Off Ver
    Mac 2011
    Posts
    1

    Re: how to find differences between 2 excel sheets

    Many thanks Malnahar! That worked perfectly for me.

    Quote Originally Posted by malnahar View Post
    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. #8
    Registered User
    Join Date
    09-11-2012
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    1

    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.

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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