Ctrl - Shift - Enter- Excel Array Formulas - Extract Unique Lists & Sorting Formulas

Overview

Dive into advanced Excel techniques with this comprehensive 55-minute video tutorial on array formulas and data extraction. Learn to extract unique lists using PivotTables, Advanced Filters, and formulas with INDEX and SMALL functions. Master helper column formulas for sorting records based on numeric and text columns. Explore array formulas for sorting and extracting top scores with associated names. Discover methods to handle unique lists of words and mixed data, including cases with empty cells. Gain practical skills in efficient data analysis and problem-solving using Excel's powerful array formulas, applicable across all Excel versions.

Syllabus

min) Extract Unique List with PivotTable..
min) Extract Unique List with Advanced Filter..
min) Extract Unique List with Formula: INDEX and SMALL functions..
min) Extract Unique List with Formula: Helper Column..
min) Extract Unique Records (more than one column) with helper column formula..
min) Sort numbers with formula..
min) Helper column formula to sort (ascending) records based on numeric column..
min) Array formula to sort (ascending) records based on numeric column..
min) Extract top 3 score and name associated with score (including ties)..
min) Helper column formula to sort (ascending) records based on text column..
min) Extract unique list of words and sort with formula when there are no empty cells..
min) Extract unique list of mixed data and sort with formula, empty cells okay..