Comparing lists in excel?


  1. Posts : 112
    Windows 7 Ultimate 64-bit
       #1

    Comparing lists in excel?


    Hi, I have 2 lists of numbers in excel, both lists are about 40000 long each. I need to see how many records match and see what ones are unmatched?

    Does anyone know of an easy way to do this? Have tried 'IF' but could only make it check individual cells rather than the whole list?

    Cheers.
      My Computer


  2. Posts : 3,009
    Windows 7 Home Premium 64bit
       #2

    I think you might find Steps: 4 & 5 useful in the following article - Use Excel to compare two lists of data - Excel - Microsoft Office :)
      My Computer


  3. Posts : 112
    Windows 7 Ultimate 64-bit
    Thread Starter
       #3

    Thanks, i couldnt figure it out from that guide, done some more googling and found the below guide if anyone else is interested, using =IFCOUNT.

    Spreadsheet Page Excel Tips: Comparing Two Lists With Conditional Formatting
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 03:27.
Find Us