Ctrl - Shift - Enter- Excel Array Formulas - Unique Count Formulas- FREQUENCY or COUNTIF Function?

Ctrl - Shift - Enter- Excel Array Formulas - Unique Count Formulas- FREQUENCY or COUNTIF Function?

ExcelIsFun via YouTube Direct link

min) Count unique numbers in a list of numbers: FREQUENCY or COUNTIF?

1 of 10

1 of 10

min) Count unique numbers in a list of numbers: FREQUENCY or COUNTIF?

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Ctrl - Shift - Enter- Excel Array Formulas - Unique Count Formulas- FREQUENCY or COUNTIF Function?

Automatically move to the next video in the Classroom when playback concludes

  1. 1 min) Count unique numbers in a list of numbers: FREQUENCY or COUNTIF?
  2. 2 min) Timing FREQUENCY and COUNTIF
  3. 3 min) Count unique numbers in a list of numbers given one condition.
  4. 4 min) Unique count formulas for mixed data.
  5. 5 min) Unique count formulas for mixed data and empty cells.
  6. 6 min) Tilde (~) to help formula to see wild cards as non-wild cards (actual characters).
  7. 7 min) Tilde to count unique items including wild cards and empty cells.
  8. 8 min) Tilde to count unique items including wild cards and empty cells with 1 condition.
  9. 9 min) Helper Column to Count Unique Items: COUNTIFS and COUNTIF functions.
  10. 10 min) Dynamic Range for Unique Count Formula

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.