Learn Excel 2010 – “VLOOKUP Into A Range of Zipcodes”: Podcast #1676

Find the Zip Code [Postal Code] That Fits!

Learn Excel from MrExcel – “Count Even or Odd Cells”: Podcast #1630

Odds and Evens in Data…and how to count them!

Dueling Excel – “Any of These in Those?”: Podcast #1516

Amazing Arrays, Virtuoso VBA and Excel-lent Executions of Triumphant Talent!

Dueling Excel – “Total All Lookups”: Podcast #1513

Extreme LOOKUP Podcast Duel

Learn Excel 2010 – “Hide and Protect”: Podcast #1442

Protect your hidden settings – with a formula?

Dueling Excel – “Collapse with a Formula”: Podcast #1429

Concatenate, Collapse, Array Formula . . . what does it all mean?

Dueling Excel – Top 2 Part II: Podcast #1399

AGGREGATE and Array Formulas to find the Top 2 in Industry…

Learn Excel – Formula Edit Fail: Podcast #1368

Array Formula Fail – and how to fix it!

Dueling Excel – Count Between Dates: Podcast #1354

A Duel? A Team Effort? You decide!

Dueling Excel – Match Month: Podcast #1349

Remember the “LOOKUP” Function? It’s Back!