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(…)

Learn Excel from MrExcel – It REALLY Pays Off!


Harini871 Won The Lottery using this MrExcel Podcast!

Learn Excel from MrExcel