How to Compare 2 Excel File in Microsoft Office 2007: Use Excel to compare two lists of data

For financial record-keeping, you often have to compare two lists to find data that appears on one but not on the other. Which new clients need to be added to the master database? Which credit card receipts are not reflected on the monthly statement, and vice versa? What checks and deposits are still outstanding? It's a tedious task if you do it manually.



Microsoft Office Excel 2003 can help you perform this task faster and more accurately. In many cases, you can do it even if the data is not provided in a standardized form in both lists.