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

Posted in ,

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Excel is not what it used to be.

You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.

Want to learn Excel?

Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.

2 Comments

  1. DaveM on June 9, 2015 at 1:39 pm

    The links appear not to work.

    • jefflenning on June 12, 2015 at 8:24 am

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

Leave a Comment





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.