Completed
min) LOOKUP when there are extra spaces in 1st column of lookup table (first column sorted).
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Ctrl - Shift - Enter- Excel Array Formulas - 26 Amazing Array Formulas
Automatically move to the next video in the Classroom when playback concludes
- 1 min) How many characters are in longest word in column?
- 2 min) Lookup Longest Word.
- 3 min) LOOKUP when there are extra spaces in 1st column of lookup table (first column NOT sorted).
- 4 min) LOOKUP when there are extra spaces in 1st column of lookup table (first column sorted).
- 5 min) Count all characters in column of text.
- 6 min) Count how many mis-typed spaces there are in column.
- 7 min) Lookup first number in row when there may be some empty cells.
- 8 min) Lookup last number in row when there may be some empty cells.
- 9 min) Lookup date associated with first number in row when there may be some empty cells.
- 10 min) Lookup Column of Data, Match Criterion, Display Items Vertically.
- 11 min) Formula to sum unique values from a column.
- 12 min) Formula to sum unique values from a row.
- 13 min) Formula to sum unique values from a column with numbers and empty cells.
- 14 min) RANK with Condition
- 15 min) CHOOSE function to "mash" 2 columns together into one lookup table.
- 16 min) Add with criteria from multiple columns across multiple sheets using SUMIF, INDIRECT and SUMPRODUCT functions.
- 17 min) Max of 2 day running total - SUBTOTAL, OFFSET and MAX function.
- 18 min) If text in cell contains 1 of 3 words, extract it.
- 19 min) Lookup Multiplying.
- 20 min) Sum Every 3rd row.
- 21 min) Extract Numbers From Text String and calculate Net Cost Equivalent.
- 22 min) Max number in succession.
- 23 min) Max text item in succession.
- 24 min) Max consecutive appearances in Bowl Games, Win or Lose .
- 25 min) How Many Friday 13th? (Formula from Bob Umlas)
- 26 min) Reverse lookup Two-Way Lookup
