Completed
min) LOOKUP when there are extra spaces in 1st column of lookup table (first column NOT 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
