MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Use a Pivot Table to Compare Lists


May 23, 2019 - by Bill Jelen

Excel Use a Pivot Table to Compare Lists. Photo Credit: Element5 Digital at Unsplash.com

When you think of comparing lists, you probably think of VLOOKUP. If you have two lists to compare, you need to add two columns of VLOOKUP. In the figure below, you are trying to compare Tuesday to Monday and Wednesday to Tuesday and maybe even Wednesday to Monday. It is going to take a lot of VLOOKUP columns to figure out who was added to and dropped from each list.

Three lists are shown in Excel. Each list has a name and a number. There are lists from Monday, Tuesday, and Wednesday.

You can use pivot tables to make this job far easier. Combine all of your lists into a single list with a new column called Source. In the Source column, identify which list the data came from.

continue reading »

More Reading


Excel Replicate a Pivot Table for Each Rep. Photo Credit: Thijs Schouten at Unsplash.com

Excel 2019: Replicate a Pivot Table for Each Rep »

May 22, 2019 - by Bill Jelen


Here is a great trick I learned from southern California–based Excel consultant Szilvia Juhasz.

Excel Use Ctrl+T with VLOOKUP and Charts. Photo Credit: Steve Johnson at Unsplash.com

Excel 2019: Use Ctrl+T with VLOOKUP and Charts »

May 20, 2019 - by Bill Jelen


It is fairly cool that you can use Ctrl+T after setting up the pivot table, VLOOKUP, or chart, and Excel still makes the range expand.

read more articles »


IMA Data Analytics Leveraging Excel

Featured Products


Microsoft Excel 2019 Inside Out

Microsoft Excel 2019 Inside Out »


Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions.

Supercharge Power BI

Supercharge Power BI »


If you want to be able to supercharge Power BI, you need to learn to write DAX. Data Analysis Expressions (DAX) is the formula language of Power BI and Power Pivot for Excel. This book prompts the reader to put your new skills to the test. Written to give you hands-on practice using Power BI Desktop and writing DAX.

MrExcel LIVe

MrExcel LIVe »


A book for people who use Excel 40+ hours per week. Illustrated in full color.

Excel JavaScript UDFs Straight to the Point

Excel JavaScript UDFs Straight to the Point »


JavaScript custom functions - UDFs can be used like any other native functions or UDFs in Excel. This book shows the process of creating JavaScript UDFs in Excel Developer Preview for Office Insider program subscribers.

The Absolute Guide to Dashboarding & Reporting with Power BI

The Absolute Guide to Dashboarding & Reporting with Power BI »


Learn Power BI Dashboarding Techniques by Watching A Pro!

Your Excel Survival Kit

Your Excel Survival Kit »


This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

see more products »