Excel Is Fun

Excel Magic Trick 1171

October 22, 2015 0

SUMIFS & SUMIF Treat 0500 & 00500 the Same! Use SUMPRODUCT Instead DESCRIPTION See how to add for Text Number Criteria such as 0500 and 00500 using SUMPRODUCT rather than SUMIFS or SUMIF: (00:08) Problem […]

Dueling Excel

Dueling Excel 046

October 21, 2015 0

Lookup a value and Retrieve the two items to the Right INDEX & MATCH DESCRIPTION See Mr Excel and excelisfun: lookup a value and the retrieve the values 1 and 2 to the right of […]

Excel VBA

Excel VBA Files and Folders

October 20, 2015 0

Excel VBA Introduction Part 22 – Files and Folders DESCRIPTION The Scripting Runtime Object Library allows you to easily write code in an Excel VBA project which can manipulate the file and folder structure of […]

Excel Is Fun

Excel Magic Trick 1170

October 19, 2015 0

VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions DESCRIPTION See how to: (00:09) Problem Setup (01:40) COLUMNS Function with expandable range to get Sequential Numbers across the columns (02:17) CHOOSE Function to […]

Excel Is Fun

Excel Magic Trick 1169

October 15, 2015 0

Are Items In Row In Master List? Filter & Conditionally Format To Highlight DESCRIPTION See how to Match Ingredients for a Drink with the data base for all drink ingregients: (00:13) Problem Setup (00:35) MATCH […]