It should also help you understand how Pivot Tables work to consolidate and summarize data. This technique is very easy to implement and does not require any formulas. We can answer all of these questions with one very simple Pivot Table. The Pivot Table List Comparison Technique Who signed up last year, but did not sign up this year?.We want to compare these lists and answer some of the following questions about our volunteers. The event has been running for three years and we have one list for each of the last three years. In this example we have lists of names for people that signed up to volunteer for a beach cleanup event.
#PIVOT TABLE IF THEN FORMULA HOW TO#
In this post I will explain how to compare two or more lists of names using a Pivot Table.
It is very easy to implement and there are NO formulas required. You will learn a simple technique to create this report using a Pivot Table.
If you have ever had to create a report that compares two or more lists in Excel, then this tutorial will really help you.