List Comparisons CalCPA Magazine Article

Hi guys!

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?

List 01

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



Get a quick email notice when a new Excel article is available

  • This field is for validation purposes and should be left unchanged.

This article was written by Jeff Lenning


  1. DaveM

    The links appear not to work.

    1. jefflenning Post author

      Thanks! Looks like their website has changed, I’ll update the link now.

Leave a Reply

Your email address will not be published. Required fields are marked *

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.