Get A Distinct Count Report With Dynamic Array Formulas!

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint... In this video, you can learn how to use the UNIQUE and COUNTIF functions to count unique rows based on multiple columns of data. This is the third video in a series looking at solutions to a Data Analysis Challenge that I gave to viewers. If you’d like to read the accompanying blog post on my website, you can access it here: https://www.excelcampus.com/functions... Related Videos: How to Count Unique Rows with Power Query:    • How to Count Unique Rows with Power Query   2 Ways to Calculate Distinct Count with Pivot Tables: https://www.excelcampus.com/pivot-tab... Excel Data Analysis Challenge - Count Transactions with Multiple Rows:    • Excel Data Analysis Challenge - Count Tran...   Dynamic Array Functions & Formulas that Spill:    • Dynamic Array Functions Are The Best New E...   Total Rows for Dynamic Array Formulas & Spill Ranges:    • Get Dynamic Array Formulas That Total Up Y...   #MsExcel #ExcelCampus 00:00 Introduction 00:13 Distinct Count Report with Dynamic Array Formulas 01:04 Dynamic Array Formulas 02:03 The UNIQUE Function 03:56 The COUNTIF Function