+ Reply to Thread
Results 1 to 2 of 2

How to compare two tables of data

  1. #1
    Registered User
    Join Date
    02-12-2009
    Location
    Varaždin, Croatia
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to compare two tables of data

    Hi,
    I have two excel tables(lists of companies with contact details) that have the same structure.First column is company name, second column is adress etc... There are some companies that appear in both tables. I need to compare those lists and cut companies that appear in both lists and paste them in sheet3. Search should be done by company name (first column).
    Thanks for help!

  2. #2
    Forum Contributor
    Join Date
    10-11-2007
    Location
    Sweden
    MS-Off Ver
    365
    Posts
    251

    Re: How to compare two tables of data

    See workbook attached.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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