Episode from the podcastChandoo.org Podcast - Become Awesome in Data Analysis, Charting, Dashboards & VBA using Excel

CP021: How to quickly compare 2 lists in Excel

Released Thursday, 2nd October 2014
Good episode? Give it some love!
In the 21st session of Chandoo.org podcast, lets compare lists. Quickly

What is in this session?

Comparing things is a favorite pastime for analysts all over the world. Sadly, it is also an area where we waste hours. So in this episode, I share my top secret comparison techniques to save you time.

Note: This is a short format podcast. That means you spend less time listening to it, while becoming more awesome.

In this podcast, you will learn,

  • Why I sound like I am on a secret mission at a mafia hideout.

  • 5 ways to compare 2 lists
    • Manual method

    • Conditional Formatting

    • Row Differences

    • LOOKUP formulas

    • COUNTIF formulas


  • Bonus tip: Removing duplicates

  • Conclusions



The post CP021: How to quickly compare 2 lists in Excel appeared first on Chandoo.org - Learn Excel, Power BI & Charting….