Excel Is Fun

Excel Magic Trick 1108

March 6, 2015 0

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

Excel Is Fun

Excel Magic Trick 1101

February 27, 2015 0

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

Excel Is Fun

Highline Excel 2013 Class Video 21

February 20, 2015 0

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 Is Fun

Highline Excel 2013 Class Video 20

February 19, 2015 0

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

Excel Is Fun

Excel Magic Trick 1100

February 7, 2015 0

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

Excel Is Fun

Excel Magic Trick 1099

February 6, 2015 0

DESCRIPTION See how to compare two e-mail lists where one list has extra semi-colons and we want a dynamic formula that can handle periodic data dumps. (00:08) Setup of problem (00:46) Excel Table Feature to […]

Excel Is Fun

Excel Magic Trick 1098

February 5, 2015 0

DESCRIPTION See how to compare two e-mail lists where one list has extra semi-colons: (00:28) Find and Replace feature to remove semi-colons (Ctrl + H). (01:32) Is in List: MATCH and ISNUMBER functions. (03:20) Is […]

Excel Is Fun

Highline Excel 2013 Class Video 02

January 24, 2015 0

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

Dueling Excel 007

January 17, 2015 0

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 Is Fun

Excel Magic Trick 1091

January 16, 2015 0

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