Remove Duplicates from a List and Use COUNTIF() in Excel 2016

In this video, you’ll learn how to remove duplicates from a list in Excel. Then, using the list of unique items, you will learn how to use COUNTIF() to count the number of times each item in the original list occurred.

Click here to download the KY High School Basketball Champions starter file if you would like to follow along with this exercise.

Own Your Own: Click here to download a list of World Series Champions that you can use to practice using COUNTIF() independently. You can try to count how many times each team has won (or lost) the series or how many times a certain manager has won (or lost) the series using the same skills that were demonstrated in the walkthrough.