+ Reply to Thread
Results 1 to 2 of 2

Compare two excel files and only extract data from one file

  1. 02-28-2018, 07:12 PM #1
    Tturner
    Tturner is offline
    Registered User
    Join Date
    03-25-2012
    Location
    Durham, NC
    MS-Off Ver
    Excel 2013
    Posts
    12

    Compare two excel files and only extract data from one file

    What is the best formula to compare data and only extract the data information from File 1 that is not in File 2 into a new sheet.

    Example: File 1
    ID First Name Last Name
    820060828 Zevandah Barnes
    823280141 Georg Herman
    820110902 Brenda Martin
    820699347 Vedia Jones-Richardson
    820802572 LaTasha Adams

    File 2
    ID First Name Last Name
    820613208 Jeremy Adams
    820802572 LaTasha Adams
    820630311 Kossi Agbeve
    820056631 Willa Allen
    820802572 Lasheka Allen

    Results
    820060828 Zevandah Barnes
    823280141 Georg Herman
    820110902 Brenda Martin
    820699347 Vedia Jones-Richardson
    Reply With QuoteRegister To Reply
  2. 02-28-2018, 08:06 PM #2
    finalazy
    finalazy is offline
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    192

    Re: Compare two excel files and only extract data from one file

    hmm if and countif?

    something like this
    =IF(A1="","",IF(COUNTIF(Sheet2!$A$1:$A1,$A$1:$A$5)=0,A1,""))
    Last edited by finalazy; 03-01-2018 at 01:50 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract data – Multiple Files – to Single File – in Excel
    By Nostradamus in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-11-2017, 12:00 PM
  2. Bypass "File has Macros" warning when opening a series of excel files to extract data?
    By StuCram in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-28-2017, 02:58 AM
  3. Extract Data From Multiple Excel Files -> One File
    By ozzabozza in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2013, 10:20 AM
  4. [SOLVED] Extract data from multiple files into a main file
    By yauchildchew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2013, 11:03 PM
  5. [SOLVED] Extract Data From Multiple Excel Files -> One File
    By Michael via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2012, 01:02 PM
  6. Extract data from several files into a summary file
    By zoomer003 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2010, 10:19 AM
  7. Sort and extract data from one excel file into multiple excel files
    By fahadq in forum Excel General
    Replies: 0
    Last Post: 06-17-2008, 12:39 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1