+ Reply to Thread
Results 1 to 2 of 2

Compare and identify unique column values from different workbooks

  1. #1
    Registered User
    Join Date
    01-22-2015
    Location
    Los Angeles, CA
    MS-Off Ver
    2010
    Posts
    14

    Post Compare and identify unique column values from different workbooks

    So let's say I have IPHost Column that lists different IP addresses

    A1 IPHost
    A2 10.20.3.238
    A3 172.16.16.1
    A4 192.15.6.5
    A5 12.10.10.1

    and so on...

    Then I have another workbook that also lists different IP addresses but I wanna find out all the unique values in the second workbook and add it to the spreadsheet above. What's the best way to do it?

    So let's say the second workbook contains:

    A1 IPHost
    A2 10.20.3.238
    A3 172.16.16.1
    A4 142.6.3.22 (unique)
    A5 192.15.6.5
    A6 184.16.3.19 (unique)

    How will I put 142.6.3.22 and 184.16.3.19 into the first workbook using Macros? And the reason why I'm asking is we have over 2,000 IP addresses on each workbook and I'm trying to find the easiest way to do it. Thank you in advance for all your help.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Homeless. I am not kidding.
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,134

    Re: Compare and identify unique column values from different workbooks

    You can probably do a vlookup to get the matched ones. The ones that are not listed on list 1 will show #N/A. Then do a filter by #N/A then copy of them over to list 1

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare and identify unique values from different workbooks
    By la_chua29 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2015, 01:44 AM
  2. Replies: 8
    Last Post: 09-25-2014, 10:14 AM
  3. Replies: 3
    Last Post: 07-24-2013, 01:23 PM
  4. Compare 2 columns of data and get unique values in the 3rd column
    By Eduard in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 04-04-2013, 08:32 AM
  5. [SOLVED] Compare two columns and list the unique values in 3rd column
    By jewellove in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2013, 10:40 AM

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