Removing Duplicates and Using the Countif( ) in Excel 2016/2019/365
Channel: Jerry.Education
Date: 2018-05-10

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 occurred in the list.

To download the Excel file used in this exercise, go to https://jerry.education/59/remove-duplicates-from-a-list-and-use-countif-in-excel-2016/

Visit https://jerry.education/59/remove-duplicates-from-a-list-and-use-countif-in-excel-2016/ to get access to a bonus file you can use to independently practice the skills demonstrated in this video.