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

Excel Is Fun

Excel Magic Trick 1086

January 10, 2015 0

DESCRIPTION 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch & Merged Cell Trouble See how to:  (00:11 min) Create formula to lookup a value from a table with three criteria: INDEX and MATCH and […]

Dueling Excel

Dueling Excel 001

January 2, 2015 0

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