Comparing lists in excel?


  1. DxxS
    Posts : 112
    Windows 7 Ultimate 64-bit
       New #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
    Quote Quote

  3. Irene
    Posts : 3,009
    Windows 7 Home Premium 64bit
       New #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
    Quote Quote

  4. DxxS
    Posts : 112
    Windows 7 Ultimate 64-bit
    Thread Starter
       New #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
    Quote Quote

 

  Related Discussions
I sent an e-mail with an attached excel. The excel takes about 8MB and that's what it says next to the name of the excel, in Outlook. But in the mail list (in the sent folder) it says that the e-mail takes up 11MB. I'm using Outlook 2007. Any ideas where this difference comes from? I don't even...
I have some sensitive material on my computer which I would not like others to see. So, I'd like to know how to exclude some folders and files from lists like recent items, jump lists, etc. Is it possible?
SSD Comparing 3 m4's
in Hardware & Devices

So what is the big difference between these three?? (besides the transfer kit) Newegg.com - Crucial M4 CT128M4SSD2BAA 2.5" 128GB SATA III MLC Internal Solid State Drive (SSD):$134.99 Newegg.com - Crucial M4 CT128M4SSD2 2.5" 128GB SATA III MLC Internal Solid State Drive (SSD):$109.99 ...
Need help with DOS Date comparing
in General Discussion

Greetings, I know that this is a Windows 7 forum, but I thought I would give it a try. My ultimate goal is to have a vbs script run after a certain date on a computer image. I thought that this would be best done with a simple batch file. In Windows XP, whenever you would create a...
Comparing all editions.
in Installation & Setup

So I visited again .. http://www.microsoft.com/windows/windows-7/compare-editions/default.aspx Other than those two difference between Professional and Ultimate is there anything else different? Honestly I could careless about Bitlocker, unless you guys think its essential.
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 20:00.
Find Us