Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Comparing lists in excel?

05 Jan 2011   #1
DxxS

Windows 7 Ultimate 64-bit
 
 
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 System SpecsSystem Spec
.
05 Jan 2011   #2
Irene

Windows 7 Home Premium 64bit
 
 

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 System SpecsSystem Spec
06 Jan 2011   #3
DxxS

Windows 7 Ultimate 64-bit
 
 

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 System SpecsSystem Spec
.

Reply

 Comparing lists in excel?




Thread Tools




Similar help and support threads
Thread Forum
excel file size differs from what outlook lists
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...
Microsoft Office
How to exclude files and folders from "Recent" lists and jump lists
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?
Customization
SSD Comparing 3 m4's
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 ...
Hardware & Devices
Need help with DOS Date comparing
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...
General Discussion
Comparing all editions.
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.
Installation & Setup


Our Sites

Site Links

About Us

Find 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 01:58.
Twitter Facebook Google+