Completed
1. Basics of FREQUENCY function -- see all aspects of how this function works mins
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Magic Trick - FREQUENCY Array Function
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Basics of FREQUENCY function -- see all aspects of how this function works mins
- 2 2. Create a Vertical Frequency Distribution mins
- 3 3. Create a Horizontal Frequency Distribution mins
- 4 4. Count unique numbers in a column mins
- 5 5. Count unique numbers in column with criteria in a second column mins
- 6 6. Count unique items in a column numbers or text mins
- 7 7. Count unique items in a column that have blank cells mins
- 8 8. Count unique items in a column including items with asterisks and that have blank cells mins
- 9 9. Count unique items numbers or text in column with criteria in a second column mins
- 10 10. Extract Unique List of Items from a column with a formula mins
- 11 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