### Dueling Excel 150

July 12, 2017

DESCRIPTION See Mr Excel and excelisfun lookup the first value in column A when the first value in B is greater than 100: (00:13) Method 1: IF function and array operation inside MIN function inside […]

### Dueling Excel 149

July 5, 2017

DESCRIPTION See Mr Excel and excelisfun have an epic back and forth duel that shows many ways to add or count with OR Criteria: (00:15) PivotTable (01:12) Excel Table feature with a Total Row with […]

### Excel Magic Trick 1302

June 29, 2017

DESCRIPTION Learn how to create an Array Formula to list multiple text modes in a single cell using the functions, MATCH, MODE.MULT, HLOOKUP and the wildcard for “any text” asterisk, “*”, and the new Excel […]

### Highline Excel 2013 Class Video 40

June 16, 2017

DESCRIPTION Topics in this video: 1. Built-in Conditional Formatting. Conditional Formatting to cells: A logical test that comes out TRUE or FALSE. TRUE = get Formatting. FALSE = Not get Formatting. 2. Highlight Cell Rules: […]

### Excel Magic Trick 1290

April 24, 2017

DESCRIPTION Learn how to create dynamic ranges using OFFSET or INDEX functions for an unusual multiple lookup table situation where the multiple tables are in a single table and the source data from a database […]

### Excel Magic Trick 1285

April 6, 2017

OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical […]

### Highline Excel 2013 Class Video 26

March 10, 2017

DESCRIPTION Topics in this video: 1. Is Item In List 2 also in List 1? Use MATCH and ISNUMBER. Comparing a prospective customer sales phone list to the companies master customer list. 2. Sort Dialog […]

### 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 […]

### 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 […]