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 Q...
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...
Dynamic Array Functions & Formulas that Spill:
Dynamic Array Functions Are The Best ...
Total Rows for Dynamic Array Formulas & Spill Ranges:
Get Dynamic Array Formulas That Total...

#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

• #education
• #excel
• #excel_campus
• #array_spill
• #dynamic_array_formulas_in_excel
• #dynamic_array_tips
• #dynamic_arrays_365
• #excel_array_formulas
• #excel_advanced_formulas
• #excel_formulas_and_functions_tutorial
• #dynamic_arrays
• #spill_range
• #spill_reference
• #spilled_array_formulas
• #spilled_arrays
• #total_rows_for_dynamic_array_formulas_spill_ranges
• #multiple_total_rows_in_excel_table