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