Results 1 to 6 of 6
  1. #1
    Enterprise IT Consultant chiefnz's Avatar
    Join Date
    Dec 2004
    Location
    Auckland
    Posts
    1,350

    Default compare 2 Excel spreadsheets

    Hi all,

    as the title says, I'm trying to compare the data in 2 different Excel spreadhseets.

    Basically we have 2 mailing lists which are in spreadsheet format. What's happened is 1 spreadsheet has been update by one group of people and the other by another group of people.

    I want to compare the 2 and then compile a new list based on the data from the existing spreadsheets minus the duplicates of course.

    Thanks in advance,

    Cheers,

    Asus P8Z77-VL X
    Intel Core i7-3770 @ 3.4GHz
    14GB DDR3 RAM
    1 x 250GB Samsung 840 Series SSD
    1 x Seagate 500GB
    3 x Western Digital 1TB
    Asus DVD/RW
    nVidia GeForce GTX 650 (Asus)
    Thermaltake V3 Black Edition with 550W PSU
    Windows 8.1 Pro

  2. #2
    Junior Member
    Join Date
    Apr 2005
    Posts
    35

    Default Re: compare 2 Excel spreadsheets

    I've used the vlookup function successfully for this purpose. The two lists have to be in the same format, type in the vlookup function in a cell beside the name, source data is the other list and the last criteria you MUST use is "FALSE". Any none matching name will retuen a value of #NA

  3. #3
    Señor Member nofam's Avatar
    Join Date
    Feb 2008
    Location
    Mollywood
    Posts
    2,322

    Default Re: compare 2 Excel spreadsheets

    Do you have MS Access?? This would be much easier if you could import the two lists as tables - then I could write you an SQL query that you could use.
    .
    .
    .

    Got a natural pearl in my calloused hand
    ...Saved for the girl who could really understand
    ......What it takes to see
    .........The gold from the alchemy

  4. #4
    Enterprise IT Consultant chiefnz's Avatar
    Join Date
    Dec 2004
    Location
    Auckland
    Posts
    1,350

    Default Re: compare 2 Excel spreadsheets

    Quote Originally Posted by nofam View Post
    Do you have MS Access?? This would be much easier if you could import the two lists as tables - then I could write you an SQL query that you could use.
    Yeah I could import it into Access 2007, thanks I'll give it ago.

    Asus P8Z77-VL X
    Intel Core i7-3770 @ 3.4GHz
    14GB DDR3 RAM
    1 x 250GB Samsung 840 Series SSD
    1 x Seagate 500GB
    3 x Western Digital 1TB
    Asus DVD/RW
    nVidia GeForce GTX 650 (Asus)
    Thermaltake V3 Black Edition with 550W PSU
    Windows 8.1 Pro

  5. #5
    Señor Member nofam's Avatar
    Join Date
    Feb 2008
    Location
    Mollywood
    Posts
    2,322

    Default Re: compare 2 Excel spreadsheets

    Cool - if you get stuck, give me the table & field names, and I'll write you some SQL that you should just be able to copy and paste
    .
    .
    .

    Got a natural pearl in my calloused hand
    ...Saved for the girl who could really understand
    ......What it takes to see
    .........The gold from the alchemy

  6. #6
    ~ >*()))><( andrew93's Avatar
    Join Date
    Dec 2004
    Posts
    1,530

    Default Re: compare 2 Excel spreadsheets

    Hi

    I'm not sure how much data you have to compare, but there is a standard menu option available in Excel to compare two workbooks - open both and then select menu option Window > Compare Side By Side > you can then have both scrolling at the same time (see also Window > Arrange > Vertical) and visually compare the data. You can even turn off the scrolling feature if they get out of sync and then turn it back on etc.

    If the data is too long then you can use lookup functions or import to Access as has been suggested.

    Andrew

Similar Threads

  1. Folder compare utility
    By Fire-and-Ice in forum PressF1
    Replies: 1
    Last Post: 13-08-2003, 02:12 PM
  2. USB ADSL Router - How do they compare?
    By nz_liam in forum PressF1
    Replies: 8
    Last Post: 25-02-2003, 11:46 PM
  3. Replies: 13
    Last Post: 29-04-2002, 06:18 AM
  4. spreadsheets
    By in forum PressF1
    Replies: 0
    Last Post: 19-09-2000, 09:50 PM
  5. Replies: 0
    Last Post: 02-02-1999, 09:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •