Ctrl + Shift + Enter: Excel Array Formulas 18: Unique Count Formulas: FREQUENCY or COUNTIF function?
This course will teach you how to count unique numbers in a list of numbers using either the FREQUENCY or COUNTIF function. You will learn how to time each function and how to count unique numbers in a list of numbers given one condition. You will also learn how to use unique count formulas for mixed data, mixed data and empty cells, and how to use the tilde (~) to help the formula to see wild cards as non-wild cards (actual characters). Additionally, you will learn how to use the tilde to count unique items including wild cards and empty cells with one condition, and how to use a helper column to count unique items with COUNTIFS and COUNTIF functions. Finally, you will learn how to create a dynamic range for a unique count formula. ▼
ADVERTISEMENT
Course Feature
Cost:
Free
Provider:
Youtube
Certificate:
Paid Certification
Language:
English
Start Date:
On-Demand
Course Overview
❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [May 30th, 2023]
Introduction:
Welcome to the Ctrl + Shift + Enter: Excel Array Formulas 18: Unique Count Formulas: FREQUENCY or COUNTIF function? course! In this course, you will learn how to count unique numbers in a list of numbers using the FREQUENCY or COUNTIF function, time FREQUENCY and COUNTIF, count unique numbers in a list of numbers given one condition, use unique count formulas for mixed data, use unique count formulas for mixed data and empty cells, use the tilde (~) to help formula to see wild cards as non-wild cards (actual characters), use the tilde to count unique items including wild cards and empty cells, use the tilde to count unique items including wild cards and empty cells with one condition, use a helper column to count unique items with COUNTIFS and COUNTIF functions, and create a dynamic range for a unique count formula.
Possible Development Paths:
This course is perfect for anyone looking to develop their Excel skills and become more proficient in data analysis. It is especially useful for those who work in data-driven fields such as finance, accounting, and business analytics. With the knowledge gained from this course, you will be able to quickly and accurately analyze data and make informed decisions.
Related Learning Suggestions:
If you are looking to further develop your Excel skills, you may want to consider taking courses on advanced Excel functions, such as pivot tables, VLOOKUP, and INDEX/MATCH. Additionally, you may want to consider taking courses on data visualization, such as creating charts and graphs in Excel. Finally, you may want to consider taking courses on data analysis, such as using Excel to analyze data sets and create reports.
Course Provider
Provider Youtube's Stats at AZClass
Discussion and Reviews
0.0 (Based on 0 reviews)
Start your review of Ctrl + Shift + Enter: Excel Array Formulas 18: Unique Count Formulas: FREQUENCY or COUNTIF function?