Learn Excel – “Sum a Column, Ignoring Error Cells” – Podcast #1791


Today, Bill shows us a Column of Numbers with a few #REF! Errors scattered throughout. We’d like to Back

Learn Excel – “Count Visible Cells Matching Criteria”: Podcast #1731


There may not be a Formula, but there is always VBA!

Dueling Excel – “MIN and MAX Between 2 Regions”: Podcast #1697


Find The Minimum and Maximum between Dates by Region.

Dueling Excel – “Address of Matching Cells”: Podcast #1641


Find That Address without A GPS!

Dueling Excel – “Slowest Time with 2 Seconds of the Fastest Time?”: Podcast #1636


Resurrecting Old Database Functions in Excel – The Duel is On!

Learn Excel from MrExcel