Excel Magic Trick - FREQUENCY Array Function

Overview

Discover the power of Excel's FREQUENCY array function in this comprehensive 52-minute video tutorial. Learn to create vertical and horizontal frequency distributions, count unique numbers and items in columns with various criteria, handle blank cells and special characters, and extract unique lists from both columns and rows. Master advanced techniques like using the TRANSPOSE function to overcome FREQUENCY's vertical array limitation. Download the accompanying Excel file to practice alongside the instructor and gain hands-on experience with 10 practical examples that showcase the versatility of this powerful Excel function.

Syllabus

1. Basics of FREQUENCY function -- see all aspects of how this function works mins
2. Create a Vertical Frequency Distribution mins
3. Create a Horizontal Frequency Distribution mins
4. Count unique numbers in a column mins
5. Count unique numbers in column with criteria in a second column mins
6. Count unique items in a column numbers or text mins
7. Count unique items in a column that have blank cells mins
8. Count unique items in a column including items with asterisks and that have blank cells mins
9. Count unique items numbers or text in column with criteria in a second column mins
10. Extract Unique List of Items from a column with a formula mins
11. Extract Unique List of Items from a row with a formula that requires the use of the TRANSPOSE function because the FREQUENCY function returns a vertical array and not a horizontal array mins