### Highline Excel 2013 Class Video 32

April 21, 2017

DESCRIPTION Topics in this video: 1. Essential definition of array formula: operation on an array of items rather than single items. 2. Example of operation on single items: subtracting 2 cells. 3. Example of operation […]

### Excel Magic Trick 1289

April 20, 2017

DESCRIPTION Why Doesn’t =ROW(1:LEN(A1)) Work? Learn 6 methods to remove “USD” from a column of values such as \$ 1.23 USD, \$ 56.34 USD, etc. that resulted from multiple downloaded CSV Files, including Replace feature, […]

### Excel Magic Trick 1278

March 13, 2017

Extract Colour From Description (Text String) Learn how to Extract Colour From Description (Text String) using LOOKUP & SEARCH functions and the Big Number 2^15 in an Array Formula. WORKBOOKS

### Excel Magic Trick 1271

February 16, 2017

DESCRIPTION Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? Learn how to extract Top 20 values and dates for those values using Formulas when there are no duplicates, Array Formula for […]

### Dueling Excel 127

February 1, 2017

DESCRIPTION Adding After & Before Dash: Array Formula or VBA? See Mr Excel and excelisfun use two methods to solve this very difficult adding problem: you must add numbers from a column of text strings […]

### Excel Magic Trick 1259

January 5, 2017

DESCRIPTION Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula? Learn how to use two lookup values to lookup an item in a table: (00:11) Problem Introduction and discussion of default behavior for VLOOKUP […]

### Excel Magic Trick 1254

December 8, 2016

DESCRIPTION Lookup Item Where 2 Values Are Closest: Helper Column or Array Formula? Learn how to create solution to lookup an item where two values are closets in value: (00:10) Problem Introduction (00:36) Helper Column […]

### Excel Magic Trick 1236

October 6, 2016

DESCRIPTION Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT? Learn how to count numbers that contain the whole number 4: (00:11) Problem Introduction (01:05) COUNTIFS formula that uses Cell References, Comparative Operators and […]

### Excel Magic Trick 1227

September 5, 2016

DESCRIPTION Conditional Format: Min, Max & Min Value Greater Than Zero Learn how to: (00:12) Problem Introduction (00:38) Conditionally Format the Maximum value in a set of numbers with built in Top 1 Rule (01:32) […]

### Excel Magic Trick 1226

September 1, 2016

DESCRIPTION Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) Learn how to Compare 2 Lists, Extract Items In List 2 That are NOT in List 1: (00:12) […]