Counting Duplicates with COUNTIF and SUMPRODUCT in Microsoft Excel

This video tutorial covers advanced Excel functions, specifically focusing on counting duplicates using COUNTIF and SUMPRODUCT. The instructor demonstrates how to apply these functions to identify duplicate and unique names within a dataset. The tutorial includes step-by-step instructions for using COUNTIF to count duplicates and calculate unique names, as well as using SUMPRODUCT for similar purposes. The session concludes with a summary and encouragement to practice these Excel functions to gain proficiency.

What steps should you take to verify the count of unique names in your data?

Explain how to find the number of duplicate names using Excel functions.