CP021: How to quickly compare 2 lists in Excel
About this episode
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 Online.
Get every episode summarized
Each time Chandoo.org Podcast - Become Awesome in Data Analytics publishes, we email you a written briefing from the transcript — the topics, who appeared, and any specific claims, with the ad reads skipped.
Email me new episodesFree for 3 shows. No card needed.
Hosts & guests
No transcript yet
This episode has not been transcribed. Request it and it moves to the front of the queue.
More episodes
More from Chandoo.org Podcast - Become Awesome in Data Analytics
CP05: Interview with MrExcel – Bill Jelen (on his incredible work ethic)
Chandoo.org Podcast - Become Awesome in Data Analytics
SQL vs. Power Query – The Ultimate Comparison
Chandoo.org Podcast - Become Awesome in Data Analytics
CP03: The Ugly Truth About Power BI (actually, 4 of them)
Chandoo.org Podcast - Become Awesome in Data Analytics
CP02: Six Tips to get a Six Figure ($100,000+) Data Job
Chandoo.org Podcast - Become Awesome in Data Analytics