MS Excel Question: File Comparison

[AggieMike88]

How do I get Excel to compare two files and based on one column of data, tell me what is different between the two?

The files have over 200 rows and rather than manually compairing to find the 1-4 that are missing in one of the files, I'm hoping Excel can do that for me.

Tips and Tricks?

 

[EdFred]

Database. Unmatched Query, FTW.

 

[CJones]

Manipulation of vlookup should be able to do what you want it to.

If it finds it, it will 'echo' the found string/data. If it doesn't find it, it will return a #N/A. You can even do a "=if(isna(vlookup(...)),0,1)" to clean the response up a bit.

 

[jesse]

Simple to do using sort and diff in bash. No idea how to do it in Excel. These fancy programs are just so hard to use!

 

[mikea]

Simple to do using sort and diff in bash. No idea how to do it in Excel. These fancy programs are just so hard to use!

How about in DOS (ummm, sorry.... Windows command line)?

C:\>FC file1.xls file2.xls