Ctrl - Shift - Enter- Excel Array Formulas - 26 Amazing Array Formulas

Ctrl - Shift - Enter- Excel Array Formulas - 26 Amazing Array Formulas

ExcelIsFun via YouTube Direct link

min) How many characters are in longest word in column?

1 of 26

1 of 26

min) How many characters are in longest word in column?

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

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.