Functions

Dueling Excel – “Prevent VLOOKUP from Returning Zero” – Podcast #1750

               

VLOOKUP Tricks and Another New DVD from ‘ExcelIsFun’!

Learn Excel – “Array Formula to Extract Records” – Podcast #1746

               

Extracting Records, New Books and Lots to Do!

Dueling Excel – “Show Formula Inputs Next to Answer” – Podcast #1740

               

Ingredients: 1 Mike Girvin; 1 Bill Jelen; Numerous ‘Fun’ctions and Formulas!

Learn Excel – “Hide Blank Rows” – Podcast #1738

               

Preserve ‘Undo’, Show All and Hide Blanks: “Go!”

Learn Excel – “Hide Blank Rows with Event Handler” – Podcast #1737

               

How to work with unseen Event Handlers and Worksheet Change Events…

Learn Excel from MrExcel