Excel Is Fun

Excel Magic Trick 1110

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

Excel Is Fun

Excel Magic Trick 1109

DESCRIPTION See how to Compare Two Lists and Extract Records with Excel Advanced Filter: 1. Extract items in list 2 that are NOT in List 1 using Advanced Filter and Logical Formula in Criteria Area [Read More >>>]

Excel Is Fun

Excel Magic Trick 1108

DESCRIPTION See how to Compare Two Lists and Extract Records: 1. ISNA and MATCH function with Filter to extract items in list 2 that are NOT in List 1. 2. ISNUMBER and MATCH function with [Read More >>>]

Excel Is Fun

Excel Magic Trick 1101

DESCRIPTION See two formulas: (04:00) MEDIAN Lower/Upper Date, Exclude Holidays: MEDAIN with IF, ISNA and MATCH (08:29) MEDIAN Lower/Upper Date, Exclude Holidays: AGGREGATE, ISNA and MATCH and Array Calculations (12:40) MEDIAN Lower/Upper Date, Exclude Holidays [Read More >>>]

Dueling Excel

Dueling Excel 019

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 [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 21

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 [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 20

DESCRIPTION Topics in this video: (00:15) VLOOKUP to retrieve whole record change columns manually. (02:20) VLOOKUP to retrieve whole record column number in cell. (03:43) VLOOKUP & MATCH to retrieve whole record — more dynamic [Read More >>>]

Dueling Excel

Dueling Excel 007

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, [Read More >>>]

Dueling Excel

Dueling Excel 001

DESCRIPTION See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a table array: Mr Excel: MATCH and INDEX functions in one formula to retrieve a value from the intersection [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 02

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 [Read More >>>]