AGGREGATE

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