formulas

Learn Excel – “Count Cells Containing Digits 423 in Any Order”: Podcast #1834

               

Can Excel count Cells that contain any sequence of the digits 423? My solution in today’s Episode #1843 seems a bit clunky. To me, it seems like the first step has to be The Formula:=SMALL(MID(TEXT(A2,’000′),{1;2;3},1)*1,1)*100+SMALL(MID(TEXT(A2,’000′),{1;2;3},1)*1,2)*10+SMALL(MID(TEXT(A2,’000′),{1;2;3},1)*1,3)*Make sure to Array-enter this formula by holding down Ctrl+Shift while pressing Enter. Although elusive, Array Formulas can be used to(…)

Dueling Excel – “Highlight Open Items after 4 Days”: Podcast #1717

               

Dueling Excel looks at Conditions and Causes – And NO VBA!

Dueling Excel – “Sum All Two-Way Lookup Matches”: Podcast #1707

               

Another Dueling Excel without a Macro! Trend this!

Learn Excel 2013 – “Split 1 Cell into 2 Cells”: Podcast #1706

               

Splitting Data in Cells and More!

Dueling Excel – “Entering Credit Card Numbers in Excel”: Podcast #1702

               

No Array Formulas and No VBA…? Is this Dueling Excel?

Learn Excel from MrExcel