Excel 2010

Learn Excel – “Show AutoFilter Selected Items”: Podcast #1827

               

Mark G has an AutoFilter outside the print range and wants to show what is selected in the AutoFilter inside the print range. Excel 2013 Table Slicers could do this, but Back

Learn Excel – “Is Text in ANY Column?”: Podcast #1826

               

Two similar questions: (1) Can I count how many Rows contain certain Text in any Column? (2) Can I Filter to only Rows that have the selected Text in Back

Learn Excel – “Show Mean on Bell Curve – 5 Ways”: Podcast #1825B

               

An addendum to Episode #1825 – several easier ways to add a line at the Mean of a Bell Curve using a Drawing object, Back

Learn Excel – “Summarize Total Row from Each Worksheet”: Podcast #1823

               

David from Fort Myers has one Worksheet for each Expense Category. The total Row appears Back

Learn Excel – “Summarize Worksheets Using INDIRECT”: Podcast #1822

               

Andrew and David have similar Excel issues – they need a Summary Worksheet to return values from all other worksheets and Back

Learn Excel from MrExcel