Just wanted to draw your attention to a recent California CPA Magazine article I wrote about comparing lists using Excel. Have you ever wanted to ask Excel to identify which items from one list appear on another? For example, which check numbers on the check register appear on the bank download, as illustrated below?
If so, this article may help as it walks through the functions needed to perform such list comparisons.
Link to issue: July 2014 CalCPA Magazine