Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
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/distinct-count-dynamic-arrays

Related Videos:
How to Count Unique Rows with Power Query:
https://www.youtube.com/watch?v=PSKMDjCtEuM
2 Ways to Calculate Distinct Count with Pivot Tables:
https://www.excelcampus.com/pivot-tables/distinctcount-pivot-tables/
Excel Data Analysis Challenge - Count Transactions with Multiple Rows:
https://www.youtube.com/watch?v=_3lX1NwIfzQ
Dynamic Array Functions & Formulas that Spill:
https://www.youtube.com/watch?v=1HF0UGMF070
Total Rows for Dynamic Array Formulas & Spill Ranges:
https://www.youtube.com/watch?v=pTbRwr4flQ8

#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