Excel Magic Trick - FREQUENCY Array Function

Excel Magic Trick - FREQUENCY Array Function

ExcelIsFun via YouTube Direct link

1. Basics of FREQUENCY function -- see all aspects of how this function works mins

1 of 11

1 of 11

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 1. Basics of FREQUENCY function -- see all aspects of how this function works mins
  2. 2 2. Create a Vertical Frequency Distribution mins
  3. 3 3. Create a Horizontal Frequency Distribution mins
  4. 4 4. Count unique numbers in a column mins
  5. 5 5. Count unique numbers in column with criteria in a second column mins
  6. 6 6. Count unique items in a column numbers or text mins
  7. 7 7. Count unique items in a column that have blank cells mins
  8. 8 8. Count unique items in a column including items with asterisks and that have blank cells mins
  9. 9 9. Count unique items numbers or text in column with criteria in a second column mins
  10. 10 10. Extract Unique List of Items from a column with a formula mins
  11. 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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.