### Dueling Excel 019

March 19, 2015

DESCRIPTION See Mr Excel and excel is fun try to use VLOOKUP to the left. Mr Excel shows how to use INDEX & MATCH to solve this problem. Excelisfun will use the LOOKUP function to […]

### Excel Magic Trick 1111

March 9, 2015

DESCRIPTION See how to extract items in List 2 that are also in List 1 using a great array formula from Exceli Adam at YouTube that uses the functions IF, INDEX, MATCH and AGGREGATE. MATCH […]

### Excel Magic Trick 1110

March 8, 2015

DESCRIPTION See how to compare two lists and extract records with an array formula that uses these functions: MATCH, ISNA, ISNUMBER, IF, ROWS, ROW, INDEX, AGGREGATE and a number of array operations. WORKBOOKS

### Dueling Excel 011

February 22, 2015

DESCRIPTION See Mr Excel and excelisfun create a formula that will randomly select a name from a list of names without having the list of names sitting in cells. See the functions INDEX, RANDBETWEEN, INT, […]

### Highline Excel 2013 Class Video 21

February 20, 2015

DESCRIPTION Topics in this video: (00:10) INDEX and MATCH. (00:32) Lookup Left, 1-way vertical range lookup. (04:41) Lookup Low Bid, 1-way horizontal range lookup. (08:27) 2-way lookup to lookup discount rate. (13:14) Lookup Whole Row […]

### Excel Magic Trick 1100

February 7, 2015

DESCRIPTION See Two Methods that can return a “Yes” when a Two Way Lookup based on a Column Header and Row Header must lookup items from a second table that presents Dimension (row / column […]

### Highline Excel 2013 Class Video 02

January 24, 2015

Comprehensive Excel Formula Types & Elements Video 12 Examples DESCRIPTION (00:39) Overview. (03:31) Hours worked formula. Type of Formula: Calculating. Formula Elements: Equal sign, parenthesis, cell reference, math operator, cell reference, parenthesis, math operator, number that […]

### Dueling Excel 010

January 20, 2015

DESCRIPTION See Mr Excel and excelisfun invert a range (Turn a range of cells upside down) with two different INDEX formulas. See the functions: INDEX ROW, ROWS, COLUMNS. See how to flip range 180 degrees […]

### Dueling Excel 007

January 17, 2015

DESCRIPTION See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA code (Macro) excelisfun uses a formula with INDEX, IF, […]

### Excel Magic Trick 1091

January 16, 2015

Count Number of Items In Row For First Occurrence of Each Group DESCRIPTION See how to count the number of items entered into the row that corresponds to the first occurrence of each Group Number […]