Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

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

ExcelIsFun via YouTube

Overview

Dive into an extensive 1-hour 21-minute video tutorial exploring 26 powerful Excel array formulas. Learn advanced techniques for data manipulation, including character counting, lookup functions with various conditions, unique value summation, conditional ranking, and multi-sheet calculations. Master complex formulas using functions like SUMIF, INDIRECT, SUMPRODUCT, SUBTOTAL, OFFSET, and MAX. Discover how to extract specific text, perform reverse lookups, and solve unique problems like counting Friday the 13ths. Enhance your Excel skills with practical applications for efficient data analysis and problem-solving across various scenarios.

Syllabus

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

Taught by

ExcelIsFun

Reviews

Start your review of Ctrl - Shift - Enter- Excel Array Formulas - 26 Amazing Array Formulas

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.