+ Reply to Thread
Results 1 to 5 of 5

Compare two data columns on two sheets

  1. #1
    Forum Contributor
    Join Date
    12-09-2006
    Posts
    229

    Compare two data columns on two sheets

    I am trying to compare tow columns of date on separate sheets. On sheet1 (Sites) there are cells that I want to compare with cells on sheet2 (Search_xls). But on sheet2 there are extra cells that are not on sheet1. I want an easy way to find these extra cells and save them on sheet3. What's the fastest way to do that without vlookup. see attached file.
    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,077
    no attachment
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Forum Contributor
    Join Date
    12-09-2006
    Posts
    229
    Here you go the file is uploaded now.

    Thanks
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,077
    Okay. I'm out of time now, but will have a look as soon as I can.

  5. #5
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Maybe put this in B1 of your search sheet

    =IF(COUNTIF($A$1:A1,Sites!A1)>=1,"Found","Not Found")

    Then filter on Not Found and copy to a new sheet

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ 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