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

Thanks

Jeff

This article was written by Jeff Lenning

2 comments:

  1. DaveM
    Reply

    The links appear not to work.

    1. jefflenning Post author
      Reply

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

Leave a Reply

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