Dive into an in-depth Excel tutorial focusing on array formulas for unique count calculations. Learn to efficiently count unique numbers in lists using FREQUENCY and COUNTIF functions, and compare their performance. Explore techniques for handling mixed data, empty cells, and wild cards in unique count formulas. Master the use of the tilde (~) operator to treat wild cards as literal characters. Discover how to create helper columns with COUNTIFS and COUNTIF functions for unique item counting. Finally, implement dynamic ranges in unique count formulas to enhance spreadsheet flexibility. Gain practical skills applicable to all Excel versions for advanced data analysis and problem-solving.
Ctrl - Shift - Enter- Excel Array Formulas - Unique Count Formulas- FREQUENCY or COUNTIF Function?
ExcelIsFun via YouTube
Overview
Syllabus
min) Count unique numbers in a list of numbers: FREQUENCY or COUNTIF?.
min) Timing FREQUENCY and COUNTIF.
min) Count unique numbers in a list of numbers given one condition..
min) Unique count formulas for mixed data..
min) Unique count formulas for mixed data and empty cells..
min) Tilde (~) to help formula to see wild cards as non-wild cards (actual characters)..
min) Tilde to count unique items including wild cards and empty cells..
min) Tilde to count unique items including wild cards and empty cells with 1 condition..
min) Helper Column to Count Unique Items: COUNTIFS and COUNTIF functions..
min) Dynamic Range for Unique Count Formula.
Taught by
ExcelIsFun
Related Courses
-
Microsoft Excel Formulas You Need to Know in 30 Minutes!
-
Ctrl - Shift - Enter- Excel Array Formulas - Extract Unique Lists & Sorting Formulas
-
Excel - Formulas & Functions Beginner to Expert Course
-
Ctrl - Shift - Enter - Excel Array Formulas - Dynamic Ranges - INDEX & OFFSET Functions
-
Ctrl - Shift - Enter- Excel Array Formulas - 26 Amazing Array Formulas
-
Ctrl - Shift - Enter- Excel Array Formulas - Formulas to Extract Records With Criteria
