Excel VBA Introduction Part 34 – Type Declarations DESCRIPTION The Type statement in VBA allows you to define your own static data structures which you can then use in your variable declarations. This video explains […]
Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functions DESCRIPTION See how to create a formula to Lookup Every 5th Item In a Column using INDEX and ROWS functions.
Sorting Formula For Biggest Sales and Sales Rep Names with Ties DESCRIPTION See Mr Excel and excelisfun create formulas for sorting biggest to smallest (descending) numbers that can deal with ties, then sort the sales […]
Excel VBA Introduction Part 33 – Creating Add Ins DESCRIPTION Creating an Excel VBA Add-In is a great way to make your custom functions available to other Excel workbooks and VBA projects. This video teaches […]
Extract Color From Description Field & Create Revenue by Color PivotTable DESCRIPTION See how: (00:09) Problem Setup (01:04) Barry Houdini at Mr Excel Message Board and pmsocho at YouTube (01:23) SEARCH function with a Function […]
Extract Many Years from Just Two Years DESCRIPTION See Mr Excel and excelisfun take the text string “1997-2000” and create a row of years consisting of 1997, 1998, 1999, 2000. See the functions LEFT, RIGHT, […]
Excel VBA Introduction Part 32 – ADO (ActiveX Data Objects) SQL Statements DESCRIPTION The ADO Command object essentially allows you to write SQL statements directly into your VBA code and execute them on whichever database […]